What is Microsoft Integration Services?
Microsoft SQL Server Integration Services (SSIS) is a platform for building high performance data integration solutions, including ETL packages for data warehousing. This includes data migration, transformation, and integration.
SSIS can retrieve information from a variety of sources and source formats, including relational databases, files, applications, etc. It's extensible, so it is possible to build connectors for other types of data sources and streams. It supports various forms of data manipulation in the data warehouse.
SSIS is a suite of tools and components and aside from the core data migration/transformation/integration tasks, it offers features for connection monitoring, task management/job control, event handling, and more.
SQL Server Integration Services first appeared as part of Microsoft SQL Server in 2005. It replaced an earlier data integration tool, Data Transformation Services (DTS).