The following are the advantages of using SSIS :
* SSIS is capable of handling the data from heterogeneous data sources in the same package
* Works with complex data, such as FTP, HTTP, MSMQ, analysis services, etc.
* Offers transformation functionality and is easier to maintain
* Tight integration with Microsoft Visual Studio and SQL Server
* Helps remove the network as a bottleneck for the insertion of data by SSIS into SQL
* Good at performing complex transformations, structured exception-handling, multi-step operations, and aggregating data from several data sources.
* Allows the loading of data in parallel across multiple destinations
