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.
|Column name||Data type||Description|
|Statistics_id||bigint||Unique ID of the data.|
|Execution_id||bigint||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).
|Executable_id||bigint||Unique ID for the package component.|
The catalog.executables view provides additional information about executables. For more information, see catalog.executables.
|Execution_path||nvarchar(max)||The full execution path of the package component, including each iteration of the component.|
|Start_time||datetimeoffset(7)||The time when the executable enters the pre-execute phase.|
|End_time||datetimeoffset(7)||The time when the executable enters the post-execute phase.|
|Execution_duration||int||The length of time the executable spent in execution. The value is in milliseconds.|
|Execution_result||smallint||The following are the possible values:|
|Execution_value||sql_variant||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.