Applies To: SQL Server 2014, SQL Server 2016 Preview
Displays a row for each executable that is run, including each iteration of an executable.
An executable is a task or container that you add to the control flow of a package.
Unique ID of the data.
Unique ID for the instance of the execution.
The catalog.executions view provides additional information about executions. For more information, see catalog.executions (SSISDB Database).
Unique ID for the package component.
The catalog.executables view provides additional information about executables. For more information, see catalog.executables.
The full execution path of the package component, including each iteration of the component.
The time when the executable enters the pre-execute phase.
The time when the executable enters the post-execute phase.
The length of time the executable spent in execution. The value is in milliseconds.
The following are the possible values:
The value that is returned by the execution. This is a user-defined value.
The view requires one of the following permissions:
READ permission on the instance of the execution.
Membership to the ssis_admin database role.
Membership to the sysadmin server role.