Export (0) Print
Expand All

catalog.event_messages

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.

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

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.

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

Community Additions

ADD
Show:
© 2014 Microsoft