Jump to content

SQL Server Integration Services

From Wikipedia, the free encyclopedia
This is an old revision of this page, as edited by 122.169.3.137 (talk) at 10:23, 26 October 2013 (→Features). The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.

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 applications. It features a fast and flexible data warehousing tool used for data extraction, transformation, and loading (ETL). The tool may also be used to automate maintenance of SQL Server databases and updates to multidimensional 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.

TEST 234

Other included tools

Aside from the Import/Export Wizard and the designer, the product includes a few other notable tools.

DTEXEC executes a package from the command line wherever it may be stored.[1][2] Before running the package, the tool may be instructed to apply configuration information, which will allow the same package to be reused with slightly different parameters, including different connection strings for its endpoints.

DTUTIL provides the ability to manage packages from the command prompt.[3][4] The tool can copy or move a package from a file into the server store, or back out again. Among a few other sundry functions,it can be used to delete, rename, encrypt, or decrypt packages.

Extensibility and programability

Users may write code to define their own connection objects, log providers, transforms, and tasks.[5][6]

SSIS features a programmable object model that allows developers to write their own hosts for package execution. Such a host can respond to events, start and stop packages, and so on. The object model also allows developers to create, store, and load packages, as well as create, destroy, and modify any of the contained objects.

Within limits, SSIS packages can load and call CLI assembly DLLs, providing access to virtually any kind of operation permissible by the .NET CLR.

SSIS can be used on all SQL Server 2005, 2008, 2008 R2, and 2012 editions except Express and Workgroup.

See also

References

  1. ^ "dtexec Utility (SSIS Tool)". Microsoft Developer Network. Microsoft. Retrieved 2013-03-24.
  2. ^ Marcin Policht (2010-08-09). "Executing SSIS Packages Using DTExec". Database Journal. Retrieved 2013-03-24.
  3. ^ "dtutil Utility (SSIS Tool)". Microsoft Developer Network. Microsoft. Retrieved 2013-03-24.
  4. ^ Yan Pan (2008-03-20). "Using dtutil to copy SSIS packages stored in SQL Server". Database Journal. Retrieved 2013-03-24.
  5. ^ "Developing a Custom Data Flow Component". Microsoft Developer Network. Microsoft. Retrieved 22 March 2013.
  6. ^ "Developing a Custom Task". Microsoft Developer Network. Microsoft. Retrieved 22 March 2013.
Retrieved from "https://en.wikipedia.org/w/index.php?title=SQL_Server_Integration_Services&oldid=578804734"