SQL Server Integration Services: Difference between revisions

Revision as of 03:07, 23 July 2014

Revision as of 19:33, 20 August 2014

Line 1:

{{Infobox software

| logo =

| screenshot =

| developer = [[Microsoft]]

| latest_release_version =

| latest_release_date =

| latest_preview_version =

| latest_preview_date =

| operating_system = [[Microsoft Windows]]

| genre = ETL Tools

| license = [[Proprietary software|Proprietary]] [[commercial software]]

| website = {{URL|http://technet.microsoft.com/en-us/library/ms141026.aspx}}

}}

'''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 [[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", "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>

==Features==

Line 60 ⟶ 73:

Within limits, SSIS packages can load and call [[Assembly (CLI)|CLI assembly]] [[Dynamic-link library|DLL]]s, providing access to virtually any kind of operation permissible by the .NET [[Common Language Runtime|CLR]].

SSIS can be used on all SQL Server [[Microsoft_SQL_Server#SQL_Server_2005|2005]], [[Microsoft_SQL_Server#SQL_Server_2008|2008]], [[Microsoft_SQL_Server#SQL_Server_2008_R2|2008 R2]], and [[Microsoft_SQL_Server#SQL_Server_2012|2012]] and [[Microsoft_SQL_Server#SQL_Server_2014|2014]] editions except Express and Workgroup.

==See also==