catalog.event_message_contextcatalog.event_message_context

适用范围:SQL Server,包括 Linux Azure SQL 数据库yesAzure SQL 数据仓库no并行数据仓库 APPLIES TO: yesSQL Server, including on Linux yesAzure SQL Database yesAzure SQL Data Warehouse noParallel Data Warehouse

适用对象: yesSQL ServeryesAzure SQL 数据库noAzure SQL 数据仓库no并行数据仓库APPLIES TO: yesSQL Server noAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

对于 Integration ServicesIntegration Services 服务器上的执行,显示与执行事件消息关联的条件的消息。Displays information about the conditions that are associated with execution event messages, for executions on the Integration ServicesIntegration Services server.

列名Column name 数据类型Data type 描述Description
Context_idContext_id BIGINTbigint 错误上下文的唯一 ID。Unique ID for the error context.
Event_message_idEvent_message_id BIGINTbigint 上下文与之相关的消息的唯一 ID。Unique ID for the message that the context relates to.
Context_depthContext_depth INTint 随着深度的增加,上下文将进一步来自错误。As the depth increases, the context is further from the error. 当错误发生时,上下文深度从 1 开始。When an error occurs, the context depth starts at 1. 值为 0 指示执行开始前包的状态。The value of 0 indicates the state of the package before execution starts.
Package_pathPackage_path Nvarchar(max)Nvarchar(max) 上下文源的包路径。The package path for the context source.
Context_typeContext_type SMALLINTsmallint 作为上下文来源的对象的类型。The type of object that is the source for the context. 有关上下文类型的列表,请参阅“备注”部分 。See the Remarks section for a list of context types.
Context_source_nameContext_source_name Nvarchar(4000)Nvarchar(4000) 作为上下文来源的对象的名称。The name of the object that is the source for the context.
Context_source_idContext_source_id Nvarchar(38)Nvarchar(38) 作为上下文来源的对象的唯一 ID。The unique ID of the object that is the source for the context.
Property_nameProperty_name Nvarchar(4000)Nvarchar(4000) 与上下文的源相关联的属性的名称。The name of the property associated with the source of the context.
Property_valueProperty_value Sql_variantSql_variant 与上下文的源相关联的属性值。The property value associated with the source of the context.

RemarksRemarks

下表列出了上下文类型。The following table lists the context types.

上下文类型值Context type value 类型名称Type Name 描述Description
1010 任务Task 出错时任务的状态。State of a task when an error occurred.
2020 管道Pipeline 错误来自管道组件:源、目标或转换组件。Error from a pipeline component: source, destination, or transformation component.
3030 序列Sequence 序列的状态。State of a sequence.
4040 For 循环For Loop For 循环的状态。State of a For Loop.
5050 ForEach 循环Foreach Loop Foreach 循环的状态。State of a Foreach Loop
6060 “包”Package 出错时包的状态。State of the package when an error occurred.
7070 变量Variable 变量值Variable value
8080 “ODBC 源编辑器”Connection manager 连接管理器的属性。Properties of a connection manager.

权限Permissions

此视图需要下列权限之一:This view requires one of the following permissions:

  • 针对操作的 READ 权限READ permission on the operation

  • ssis_admin 数据库角色的成员资格。Membership to the ssis_admin database role.

  • sysadmin 服务器角色的成员资格。Membership to the sysadmin server role.