Chapter 16. SSIS Catalog Deep Dive

SSIS Catalog Deep Dive

SSIS 2012 introduces new capabilities that make it easier to deploy, configure, and manage SSIS packages in the enterprise. SSIS packages are deployed to the SSIS Catalog. On each SQL Server instance with SSIS installed, this corresponds to the user database, called SSISDB. SSISDB consists of a set of internal and public stored procedures (both T-SQL and CLR stored procedures), scalar-value functions and table-value functions (TVFs). Collectively, these provide the capabilities for SSIS 2012.

SSIS 2012 uses SQLCLR ...

Get Microsoft® SQL Server® 2012 Integration Services now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.