O'Reilly logo

Professional Microsoft SQL Server 2014 Integration Services by Chris Rock, Mike Davis, Jessica M. Moss, Devin Knight, Brian Knight

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

Appendix BSSIS Internal Views and Stored Procedures

In this appendix you find an abbreviated table of some of the stored procedures and views that may be helpful for an administrator when hacking the SSISDB catalog. For the most part, you want to use the views instead of the underlying tables since the tables may change during service packs or new versions of SQL Server. It is for this reason the tables are not in the appendix. This list is not comprehensive but focuses on the commonly used ones when you want to hack the SSIS catalog.

VIEWS

VIEW USE
catalog.catalog_properties Contains all the properties of the SSIS catalog.
catalog.environment_variables Lists all the variables used by a set of environments.
catalog.environments Contains a list of SSIS environments in folders. You may need to reference this view to see what potential environments you have when running a package through T-SQL.
catalog.executions Each time you execute a package, a row is shown here. Shows the amount of resources being allocated to the package. Shows the duration of the package runtime, who ran the package, and from what machine.
catalog.event_messages As a package runs, several rows are shown here for each successful run of a step.
catalog.folders Contains a list of folders in the catalogs.
catalog.execution_data_statistics When the package runs in verbose mode, the package shows the statistics about the package runtime and rows sent.
catalog.object_parameters Shows a list of ...

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