SQL Server Integration Services: Difference between revisions

Revision as of 10:12, 16 May 2012

Revision as of 01:53, 30 May 2012

Line 60:

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 [[.NET assembly|.NET 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]] editions except Express and Workgroup.