Applies To: SQL Server 2014, SQL Server 2016 Preview
Displays information about messages that were logged during operations.
The unique ID of the event message.
The type of operation.
For a list of operation types, see catalog.operations (SSISDB Database).
The time the message was created.
The type of message displayed. For more information about message types, see catalog.operation_messages (SSISDB Database).
The source of the message.
The text of the message.
The ID of additional information that relates to the operation message, found in the catalog.extended_operation_info (SSISDB Database) view.
The name of the package file.
The run-time event associated with the message.
The package component that is the source of the message.
The unique ID of the source of the message.
The data flow component that is the source of the message.
When messages are returned by the Integration Services engine, SSIS.Pipeline appears in this column.
The unique path of the component within the package.
The full path from the parent package to the point in which the component is executed.
This path also captures iterations of a component.
ID for the thread that is executing when the message is logged.
The code associated with the message.
This view displays the following message source types.
Entry APIs, such as T-SQL and CLR Stored procedures
External process used to run package (ISServerExec.exe)
Control Flow tasks
Control Flow containers
Data Flow task
This view requires one of the following permissions:
READ permission on the operation
Membership to the ssis_admin database role.
Membership to the sysadmin server role.