catalog.operation_messages(SSISDB 数据库)catalog.operation_messages (SSISDB Database)

适用对象:是SQL Server,包含 Linux 版 是Azure SQL 数据库 是Azure Synapse Analytics (SQL DW) 否并行数据仓库 APPLIES TO: yesSQL Server, including on Linux yesAzure SQL Database yesAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

适用对象: 是SQL Server 否Azure SQL 数据库 否Azure Synapse Analytics (SQL DW) 否并行数据仓库 APPLIES TO: yesSQL Server noAzure SQL Database noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

显示在 Integration ServicesIntegration Services 目录中执行操作期间记录的消息。Displays messages that are logged during operations in the Integration ServicesIntegration Services catalog.

列名Column name 数据类型Data type 描述Description
operation_message_idoperation_message_id bigintbigint 消息的唯一标识符 (ID)。The unique identifier (ID) of the message.
operation_idoperation_id bigintbigint 操作的唯一 ID。The unique ID of the operation.
message_timemessage_time datetimeoffset(7)datetimeoffset(7) 创建消息时的时间。The time when the message was created.
message_typemessage_type smallintsmallint 所显示的消息的类型。The type of message displayed.
message_source_typemessage_source_type smallintsmallint 消息源类型的 ID。The ID of the type of message source.
messagemessage nvarchar(max)nvarchar(max) 消息的文本。The text of the message.
extended_info_idextended_info_id bigintbigint 与在 extended_operation_info 视图中找到的操作消息相关的附加信息的 ID。The ID of additional information that relates to the operation message, found in the extended_operation_info view.


此视图对于在目录中执行操作期间记录的每条消息显示一行。This view displays a row for each message that is logged during an operation in the catalog. 此消息可以由服务器、包执行进程或执行引擎生成。The message can be generated by the server, by the package execution process, or by the execution engine.

此视图显示下列消息类型:This view displays the following message types:

message_type Valuemessage_type Value 描述Description
-1-1 UnknownUnknown
120120 错误Error
110110 警告Warning
7070 信息Information
1010 预验证Pre-validate
2020 后验证Post-validate
3030 预执行Pre-execute
4040 后执行Post-execute
6060 进度Progress
5050 StatusChangeStatusChange
100100 QueryCancelQueryCancel
130130 TaskFailedTaskFailed
9090 诊断Diagnostic
200200 自定义Custom
140140 DiagnosticExDiagnosticEx

每当执行包任务执行子包时,都会记录此事件。Whenever an Execute Package task executes a child package, it logs this event. 此事件消息包含传递到子包的参数值。The event message consists of the parameter values passed to child packages.

DiagnosticEx 的消息列的值是 XML 文本。The value of the message column for DiagnosticEx is XML text.
400400 NonDiagnosticNonDiagnostic
8080 VariableValueChangedVariableValueChanged

此视图显示下列消息源类型。This view displays the following message source types.

message_source_typemessage_source_type 描述Description
1010 入口 API,如 T-SQL 和 CLR 存储过程Entry APIs, such as T-SQL and CLR Stored procedures
2020 用来运行包的外部进程 (ISServerExec.exe)External process used to run package (ISServerExec.exe)
3030 包级别对象Package-level objects
4040 控制流任务Control Flow tasks
5050 控制流容器Control Flow containers
6060 数据流任务Data Flow task


此视图需要下列权限之一: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


当您具有在服务器上执行操作的权限时,您还具有查看有关此操作的信息的权限。When you have permission to perform an operation on the server, you also have permission to view information about the operation. 将实施行级安全性;只显示您有权查看的行。Row-level security is enforced; only rows that you have permission to view are displayed.