Applies To: SQL Server 2014, SQL Server 2016 Preview
Displays information about the conditions that are associated with execution event messages, for executions on the Integration Services server.
Unique ID for the error context.
Unique ID for the message that the context relates to.
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.
The package path for the context source.
The type of object that is the source for the context. See the Remarks section for a list of context types.
The name of the object that is the source for the context.
The unique ID of the object that is the source for the context.
The name of the property associated with the source of the context.
The property value associated with the source of the context.
The following table lists the context types.
Context type value
State of a task when an error occurred.
Error from a pipeline component: source, destination, or transformation component.
State of a sequence.
State of a For Loop.
State of a Foreach Loop
State of the package when an error occurred.
Properties 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.