catalog.event_message_context

 

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2012)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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

Column nameData typeDescription
Context_idbigintUnique ID for the error context.
Event_message_idbigintUnique ID for the message that the context relates to.
Context_depthintAs 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_pathNvarchar(max)The package path for the context source.
Context_typesmallintThe type of object that is the source for the context. See the Remarks section for a list of context types.
Context_source_nameNvarchar(4000)The name of the object that is the source for the context.
Context_source_idNvarchar(38)The unique ID of the object that is the source for the context.
Property_nameNvarchar(4000)The name of the property associated with the source of the context.
Property_valueSql_variantThe property value associated with the source of the context.

The following table lists the context types.

Context type valueType NameDescription
10TaskState of a task when an error occurred.
20PipelineError from a pipeline component: source, destination, or transformation component.
30SequenceState of a sequence.
40For LoopState of a For Loop.
50Foreach LoopState of a Foreach Loop
60PackageState of the package when an error occurred.
70VariableVariable value
80Connection managerProperties of a connection manager.

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: