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.

DTS 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:

Related Content

Hide Details

Search Code: 4171
Published: August 21, 2007
Last Revised: August 21, 2007

Social

Get Access

Get Instant Access
To unlock the full content, please fill out our simple form and receive instant access.