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

catalog.event_messages

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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.

Community Additions

ADD
Show:
© 2015 Microsoft