There are some disadvantages while using SSIS. They are as follows :
* If we need to see the report of package execution, then we will have to install new software called Management Studio. SSIS does not have the option to publish to reporting services.
* SSIS utilizes high memory which can cause conflicts with memory utilization of SQL. This causes problems if there are requirements to run multiple packages in parallel.
* SSIS also uses high CPU resources which again results in problems while running multiple packages parallely. Proper CPU allocation needs to be ensured between SQL and SSIS to avoid either of them running slow.
