SQL Server Integration Services: Difference between revisions

Revision as of 17:25, 4 February 2014

Revision as of 15:47, 13 May 2014

Line 1:

'''SQL Server Integration Services''' ('''SSIS''') is a component of the [[Microsoft SQL Server]] database software that can be used to perform a broad range of [[data migration]] tasks.

'''SSIS''' is a platform lun pe choro knjro for [[data integration]] and [[workflow application]]s. It features a fast and flexible [[data warehouse|data warehousing]] tool used for data extraction, transformation, and loading ([[Extract, transform, load|ETL]]). The tool may also be used to automate maintenance of SQL Server databases and updates to multidimensional [[OLAP cube|cube data]].

First released with Microsoft SQL Server 2005, SSIS replaced [[Data Transformation Services]], which had been a feature of SQL Server since Version 7.0. Unlike DTS, which was included in all versions, SSIS is only available in the "Standard" and "Enterprise" editions.