catalog.event_message_context

Applies to: yesSQL Server (all supported versions) yes SSIS Integration Runtime in Azure Data Factory

Applies to: yesSQL Server (all supported versions)

Displays information about the conditions that are associated with execution event messages, for executions on the Integration Services server.

Column name Data type Description
Context_id bigint Unique ID for the error context.
Event_message_id bigint Unique ID for the message that the context relates to.
Context_depth int As the depth increases, the context is further from the error. When an error occurs, the context depth starts at 1. The value of 0 indicates the state of the package before execution starts.
Package_path Nvarchar(max) The package path for the context source.
Context_type smallint The type of object that is the source for the context. See the Remarks section for a list of context types.
Context_source_name Nvarchar(4000) The name of the object that is the source for the context.
Context_source_id Nvarchar(38) The unique ID of the object that is the source for the context.
Property_name Nvarchar(4000) The name of the property associated with the source of the context.
Property_value Sql_variant The property value associated with the source of the context.

Remarks

The following table lists the context types.

Context type value Type Name Description
10 Task State of a task when an error occurred.
20 Pipeline Error from a pipeline component: source, destination, or transformation component.
30 Sequence State of a sequence.
40 For Loop State of a For Loop.
50 Foreach Loop State of a Foreach Loop
60 Package State of the package when an error occurred.
70 Variable Variable value
80 Connection manager Properties of a connection manager.

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.