Viewing and Stopping Packages Running on the Integration Services Server

The SSISDB database stores execution history in internal tables that are not visible to users. However it exposes the information that you need through public views that you can query. It also provides stored procedures that you can call to perform common tasks related to packages.

Typically you manage Integration Services objects on the server in SQL Server Management Studio. However you can also query the database views and call the stored procedures directly, or write custom code that calls the managed API. SQL Server Management Studio and the managed API query the views and call the stored procedures to perform many of their tasks. For example, you can view the list of Integration Services packages that are currently running on the server, and request packages to stop if you have to.

Viewing the List of Running Packages

You can view the list of packages that are currently running on the server in the Active Operations dialog box. For more information, see Active Operations Dialog Box.

For information about the other methods that you can use to view the list of running packages, see the following topics.

Stopping a Running Package

You can request a running package to stop in the Active Operations dialog box. For more information, see Active Operations Dialog Box.

For information about the other methods that you can use to stop a running package, see the following topics.

Viewing the History of Packages That Have Run

To view the history of packages that have run in Management Studio, use the All Executions report. For more information on the All Executions report and other standard reports, see Operations Reports for the Integration Services Server.

For information about the other methods that you can use to view the history of running packages, see the following topics.

Integration Services icon (small) Stay Up to Date with Integration Services

For the latest downloads, articles, samples, and videos from Microsoft, as well as selected solutions from the community, visit the Integration Services page on MSDN:


For automatic notification of these updates, subscribe to the RSS feeds available on the page.

See Also

Tasks

Execution of Projects and Packages

Concepts

Troubleshooting Reports for Package Execution