SQL Server Integration Services: Difference between revisions

Revision as of 08:09, 10 March 2006

Revision as of 08:10, 10 March 2006

Line 1:

'''SQL Server Integration Services''' ('''SSIS''') is a component of [[Microsoft SQL Server]] 2005. It replaces [[Data Transformation Services]], a feature of SQL Server since Version 7.0.

[[Image:http://msdn2.microsoft.com/en-us/library/ms141026.Local_-1605283248_max_sql_arch_dts.gif]]

Integration Services provides a platform to build data integration and workflow applications. The primary use for SSIS is [[data warehouse|data warehousing]], as the product features a fast and flexible data extraction, transformation, and loading ([[Extract, transform, load|ETL]]) engine. The tool may also be used to automate maintenance of SQL Server databases.