Export (0) Print
Expand All
1 out of 1 rated this helpful - Rate this topic

catalog.event_message_context

SQL Server 2012

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.

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.