.png)
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. |
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. |
