catalog.event_messages

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2012)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Displays information about messages that were logged during operations.

Column name Data type Description
Event_message_ID bigint The unique ID of the event message.
Operation_id bigint The type of operation.

For a list of operation types, see catalog.operations (SSISDB Database).
Message_time datetimeoffset(7) The time the message was created.
Message_type smallint The type of message displayed. For more information about message types, see catalog.operation_messages (SSISDB Database).
Message_source_type smallint The source of the message.
message nvarchar(max) The text of the message.
Extended_info_id bigint The ID of additional information that relates to the operation message, found in the catalog.extended_operation_info (SSISDB Database) view.
Package_name nvarchar(260) The name of the package file.
Event_name nvarchar(1024) The run-time event associated with the message.
Message_source_name nvarchar(4000) The package component that is the source of the message.
Message_source_id nvarchar(38) The unique ID of the source of the message.
Subcomponent_name nvarchar(4000) 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.
Package_path nvarchar(max) The unique path of the component within the package.
Execution_path nvarchar(max) The full path from the parent package to the point in which the component is executed.

This path also captures iterations of a component.
threadID int ID for the thread that is executing when the message is logged.
Message_code int The code associated with the message.

Remarks

This view displays the following message source types.

message_source_type Description
10 Entry APIs, such as T-SQL and CLR Stored procedures
20 External process used to run package (ISServerExec.exe)
30 Package-level objects
40 Control Flow tasks
50 Control Flow containers
60 Data Flow task

Permissions

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.

See Also

catalog.event_message_context