catalog.event_message_context
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.