Stored Procedures (Integration Services Catalog)

This section describes the Transact-SQL stored procedures that are available for administering Integration Services projects that have been deployed to an instance of SQL Server.

Call the Integration Services stored procedures to add, remove, modify, or execute objects that are stored in the SSISDB catalog.

The default name of the catalog is SSISDB. The objects that are stored in the catalog include projects, packages, parameters, environments, and operational history.

You can use the database views and stored procedures directly, or write custom code that calls the managed API. Management Studio and the managed API query the views and call the stored procedures that are described in this section to perform many of their tasks.

In This Section