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 nameData typeDescription
Statistics_idbigintUnique ID of the data.
Execution_idbigintUnique 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_idbigintUnique ID for the package component.

The catalog.executables view provides additional information about executables. For more information, see catalog.executables.
Execution_pathnvarchar(max)The full execution path of the package component, including each iteration of the component.
Start_timedatetimeoffset(7)The time when the executable enters the pre-execute phase.
End_timedatetimeoffset(7)The time when the executable enters the post-execute phase.
Execution_durationintThe length of time the executable spent in execution. The value is in milliseconds.
Execution_resultsmallintThe following are the possible values:

0 (Success)

1 (Failure)

2 (Completion)

3 (Cancelled)
Execution_valuesql_variantThe 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.

Community Additions

ADD
Show: