SQL Server 2008 Integration Services (SSIS) provides data movement and transformation capabilities for SQL Server. Just as in SQL Server 2005, SSIS replaces SQL Server 2000 Data Transformation Services (DTS). SSIS provides for the following data services:
This triumvirate of data services is frequently referred to as ETL. The process ...