RETIRED CONTENTPlease note that the content on this page is retired. This content is not maintained and may contain information or links that are out of date.
Microsoft's SQL Server 2005 Integration Services (SSIS) are a platform of tools for exporting data from databases to other locations, allowing for the centralization of data from various sources. Apart from warehousing capabilities and functions, SSIS handles a host of other data-movement tasks.
Data Transformation Services (DTS) were originally built into SQL Server 7.0. These new tools were readily accepted by the IT community, allowing SQL server developers and database administrators to improve productivity by automating data extraction, transformation, and loading (ETL) tasks. DTS tools released with SQL Server 2000 proved to be even more robust, including such tasks as: