O'Reilly logo

Microsoft® SQL Server® 2012 Integration Services by Rakesh Parida Wee-Hyong Tok Matt Masson, Xiaoning Ding, and Kaarthik Sivashanmugam

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required