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 nameData typeDescription
executable_idbigintThe unique identifier for the executable.
execution_idbigintThe unique identifier for the instance of execution.
executable_namenvarchar(4000)The name of the executable.
executable_guidnvarchar(38)The GUID of the executable.
package_namenvarchar(260)The name of the package.
package_pathnvarchar(max)The path of the package.

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

System_CAPS_ICON_note.jpg 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.

Community Additions