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

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