catalog.executable_statistics
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. |
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.