catalog.event_message_context

Applies to: SQL Server SSIS Integration Runtime in Azure Data Factory

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.

This view requires one of the following permissions: