catalog.executable_statistics

  • Article

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.