Chapter 12. SSIS T-SQL Magic

Overview of SSIS Stored Procedures and Views

SSIS 2012 introduces new views, stored procedures and table-value functions that provide powerful capabilities and a rich set of information for a database administrator. These views and stored procedures are available in the user database, called SSISDB, in a SQL Server instance.

Users should take advantage of the stored procedures, table-value function, and views in SSISDB that are using the catalog schema. All database users of SSISDB can access these stored procedures, table-value functions, and views. When invoking the stored procedures, ...

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.