When the ancestor of SQL Server Integration Services (SSIS)—Data Transformation Services (DTS)—was initially released with SQL Server 7.0, database administrators were extremely pleased. DTS not only replaced old data transformation and loading tools, but also added new features that significantly simplified their lives. However, only in SQL Server 2000 did DTS become a modern Extract, transform, load (ETL) tool, which set up a foundation for SQL Server Integration Services.

SSIS was originally released with SQL Server 2005 with the intention of replacing DTS. SSIS 2005 was a full-featured data integration engine and development environment to build high-performance solutions. After several more versions, SSIS became a development platform to build quality data integration, migration, and transformation solutions. Typical scenarios for the usage of SSIS include the following: