catalog.executable_statistics

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

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:

0 (Success)

1 (Failure)

2 (Completion)

3 (Cancelled)
Execution_value sql_variant The value that is returned by the execution. This is a user-defined value.

Permissions

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.