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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
