catalog.event_messagescatalog.event_messages

适用范围: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

显示有关在操作期间已记入日志的消息的信息。Displays information about messages that were logged during operations.

列名Column name 数据类型Data type 描述Description
Event_message_IDEvent_message_ID BIGINTbigint 事件消息的唯一 ID。The unique ID of the event message.
Operation_idOperation_id BIGINTbigint 操作的类型。The type of operation.

有关操作类型的列表,请参阅 catalog.operations(SSISDB 数据库)For a list of operation types, see catalog.operations (SSISDB Database).
Message_timeMessage_time datetimeoffset(7)datetimeoffset(7) 创建消息的时间。The time the message was created.
Message_typeMessage_type SMALLINTsmallint 所显示的消息的类型。The type of message displayed. 有关消息类型的详细信息,请参阅 catalog.operation_messages(SSISDB 数据库)For more information about message types, see catalog.operation_messages (SSISDB Database).
Message_source_typeMessage_source_type SMALLINTsmallint 消息的源。The source of the message.
messagemessage nvarchar(max)nvarchar(max) 消息的文本。The text of the message.
Extended_info_idExtended_info_id BIGINTbigint 与在 catalog.extended_operation_info(SSISDB 数据库)视图中找到的操作消息相关的附加信息的 ID。The ID of additional information that relates to the operation message, found in the catalog.extended_operation_info (SSISDB Database) view.
Package_namePackage_name nvarchar(260)nvarchar(260) 包文件的名称。The name of the package file.
Event_nameEvent_name nvarchar(1024)nvarchar(1024) 与消息关联的运行时事件。The run-time event associated with the message.
Message_source_nameMessage_source_name nvarchar(4000)nvarchar(4000) 作为消息源的包组件。The package component that is the source of the message.
Message_source_idMessage_source_id nvarchar(38)nvarchar(38) 消息源的唯一 ID。The unique ID of the source of the message.
Subcomponent_nameSubcomponent_name nvarchar(4000)nvarchar(4000) 作为消息源的数据流组件。The data flow component that is the source of the message.

Integration ServicesIntegration Services 引擎返回消息时,SSIS.Pipeline 将出现在该列中。When messages are returned by the Integration ServicesIntegration Services engine, SSIS.Pipeline appears in this column.
Package_pathPackage_path nvarchar(max)nvarchar(max) 包内组件的唯一路径。The unique path of the component within the package.
Execution_pathExecution_path nvarchar(max)nvarchar(max) 从父包到执行该组件的点的完整路径。The full path from the parent package to the point in which the component is executed.

此路径还捕获组件的迭代。This path also captures iterations of a component.
threadIDthreadID INTint 将消息记入日志时正在执行的线程的 ID。ID for the thread that is executing when the message is logged.
Message_codeMessage_code INTint 与此消息关联的代码。The code associated with the message.

RemarksRemarks

此视图显示下列消息源类型。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

权限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.

另请参阅See Also

catalog.event_message_contextcatalog.event_message_context