The following are some of the most important features of SSIS :
* Improves data quality by providing data cleansing and profiling
* Helps in smooth data integration from several data sources
* Easy integration with other components of Microsoft SQL products
* Enriched studio environment and graphical tools
* Offers workflow functionalities such as file transfer protocol
* Provides the APIs for SSIS object modeling
* Implements high-speed data connectivity efficiently
* Comes with packaged data source connectors
* Organizes data mining query and lookup transformation
