SSIS: SQL Server's Secret Weapon


Download

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

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:

Hide Details

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

Related Content

GET HELP Contact Us
×
VL Methodology