catalog.extended_operation_info (SSISDB Database)
Displays extended information for all operations in the Integration Services catalog.
|Column name||Data type||Description|
|info_id||bigint||The unique identifier (ID) of the extended information.|
|operation_id||bigint||The unique ID of the operation that corresponds to the extended information.|
|object_name||nvarchar(260)||The name of the object.|
|object_type||smallint||The type of object affected by the operation. The object may be a folder (|
|reference_id||bigint||The unique ID of the reference that is used in the operation.|
|status||int||The status of the operation. The possible values are created (|
|start_time||datetimeoffset(7)||The date and time at which the operation started.|
|end_time||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 permission on the operation
Membership to the ssis_admin database role
Membership to the sysadmin server role