catalog.operations (SSISDB Database)

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2012)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Displays the details of all operations in the Integration Services catalog.

Column name Data type Description
operation_id bigint The unique identifier (ID) of the operation.
operation_type smallint The type of operation.
created_time datetimeoffset The time when the operation was created.
object_type smallint The type of object affected by the operation. The object may be a folder (10), project (20), package (30), environment (40), or instance of execution (50).
object_id bigint The ID of the object affected by the operation.
object_name nvarchar(260) The name of the object.
status int The status of the operation. 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_time datetimeoffset The time when the operation started.
end_time datetimeoffsset The time when the operation ended.
caller_sid varbinary(85) The security ID (SID) of the user if Windows Authentication was used to log on.
caller_name nvarchar(128) The name of the account that performed the operation.
process_id int The process ID of the external process, if applicable.
stopped_by_sid varbinary(85) The SID of the user who stopped the operation.
stopped_by_name nvarchar(128) The name of the user who stopped the operation.
server_name nvarchar(128) The Windows server and instance information for a specified instance of SQL Server.
machine_name nvarchar(128) The computer name on which the server instance is running.

Remarks

This view displays one row for each operation in the Integration Services catalog. It allows the administrator to enumerate all the logical operations that were performed on the server, such as deploying a project or executing a package.

This view displays the following operation types, as listed in the operation_type column:

operation_type Value operation_type Description object_id Description object_name Description
1 Integration Services initialization NULL NULL
2 Retention window

(SQL Agent job)
NULL NULL
3 MaxProjectVersion

(SQL Agent job)
NULL NULL
101 deploy_project

(Stored procedure)
Project ID Project name
106 restore_project

(Stored procedure)
Project ID Project name
200 create_execution and start_execution

(Stored procedures)
Project ID NULL
202 stop_operation

(Stored procedure)
Project ID NULL
300 validate_project

(Stored procedure)
Project ID Project name
301 validate_package

(Stored procedure)
Project ID Package name
1000 configure_catalog

(Stored procedure)
NULL NULL

Permissions

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

Note

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.