Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Monitoring for Package Executions and Other Operations


You can monitor Integration Services package executions, project validations, and other operations by using one of more of the following tools. Certain tools such as data taps are available only for projects that are deployed to the Integration Services server.

Several different types of operations are monitored in the SSISDB catalog, on the Integration Services server. Each operation can have multiple messages associated with it. Each message can be classified into one of several different types. For example, a message can be of type Information, Warning, or Error. For the full list of message types, see the documentation for the Transact-SQL catalog.operation_messages (SSISDB Database) view. For a full list of the operations types, see catalog.operations (SSISDB Database).

Nine different status types are used to indicate the status of an operation. For a full list of the status types, see the catalog.operations (SSISDB Database) view.

Blog entry, SSIS T-SQL API Overview, on blogs.msdn.com.

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft