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