Monitor Running Packages and Other Operations
Applies To: SQL Server 2016
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.
For more information, see Integration Services (SSIS) Logging.
For more information, see Reports for the Integration Services Server.
For more information, see Views (Integration Services Catalog).
For more information, see Performance Counters.
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.