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