SQL Server Integration Services: Difference between revisions

Revision as of 12:23, 22 February 2017

Revision as of 03:21, 14 March 2017

Line 14:

'''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 for [[data integration]] and [[workflow application]]s. It features a fast and flexible{{Citation needed|date=February 2017}} [[data warehouse|data warehousing]] tool used for data [[Extract, transform, load|extraction, transformation, and loading (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", "Business Intelligence" and "Enterprise" editions.<ref>{{cite web | title = Features Supported by the Editions of SQL Server 2014 | url = http://msdn.microsoft.com/en-gb/library/cc645993.aspx#SSIS|website=msdn.microsoft.com | publisher = Microsoft Developer Network | accessdate = 20 August 2014}}</ref>