catalog.extended_operation_info(SSISDB 数据库)catalog.extended_operation_info (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 extended information for all operations in the Integration ServicesIntegration Services catalog.

列名Column name 数据类型Data type 描述Description
info_idinfo_id bigintbigint 扩展信息的唯一标识符 (ID)。The unique identifier (ID) of the extended information.
operation_idoperation_id bigintbigint 对应于扩展信息的操作的唯一 ID。The unique ID of the operation that corresponds to the extended information.
object_nameobject_name nvarchar(260) nvarchar(260) 对象的名称。The name of the object.
object_typeobject_type smallintsmallint 受操作影响的对象的类型。The type of object affected by the operation. 该对象可能是文件夹 (10)、项目 (20)、包 (30)、环境 (40) 或执行实例 (50)。The object may be a folder (10), project (20), package (30), environment (40), or instance of execution (50).
reference_idreference_id bigintbigint 操作中使用的引用的唯一 ID。The unique ID of the reference that is used in the operation.
statusstatus intint 操作的状态。The status of the operation. 可能的值是已创建 (1)、正在运行 (2)、已取消 (3)、失败 (4)、挂起 (5)、意外结束 (6)、已成功 (7)、停止 (8) 和已完成 (9)。The possible values are created (1), running (2), canceled (3), failed (4), pending (5), ended unexpectedly (6), succeeded (7), stopping (8), and completed (9).
start_timestart_time datetimeoffset(7)datetimeoffset(7) 操作开始的日期和时间。The date and time at which the operation started.
end_timeend_time datetimeoffset(7)datetimeoffset(7) 操作结束的日期和时间。The date and time at which the operation ended.


单个操作可以有多个扩展的信息行。A single operation can have multiple extended information rows.


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