Export (0) Print
Expand All

catalog.event_message_context

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft