catalog.executable_statistics
Applies to: SQL Server SSIS Integration Runtime in Azure Data Factory
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.