Udostępnij za pośrednictwem


Views (Integration Services Catalog)

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

Query the Integration Services views to inspect objects, settings, and operational data 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