catalog.executables

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

This view displays a row for each executable in the specified execution.

An executable is a task or container that you add to the control flow of a package.

Column name Data type Description
executable_id bigint The unique identifier for the executable.
execution_id bigint The unique identifier for the instance of execution.
executable_name nvarchar(4000) The name of the executable.
executable_guid nvarchar(38) The GUID of the executable.
package_name nvarchar(260) The name of the package.
package_path nvarchar(max) The path of the package.

Permissions

This view requires one of the following permissions:

  • READ permission on the instance of execution

  • 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.

Remarks