catalog.execution_component_phases
Displays the time spent by a data flow component in each execution phase.
|
Column name |
Data type |
Description |
|---|---|---|
|
phase_stats_id |
bigint |
Unique identifier (ID) of the phase. |
|
execution_id |
bigint |
Unique ID for the instance of execution. |
|
package_name |
nvarchar(260) |
The name of the first package that was started during execution. |
|
task_name |
nvarchar(4000) |
The name of the data flow task. |
|
subcomponent_name |
nvarchar(4000) |
The name of the data flow component. |
|
phase |
nvarchar(128) |
The name of the execution phase. |
|
start_time |
datetimeoffset(7) |
The time when the phase started. |
|
end_time |
datetimeoffset(7) |
The time when the phase ended. |
|
execution_path |
nvarchar(max) |
The execution path of the data flow task. |
This view requires one of the following permissions:
-
READ permission on the instance of execution
-
Membership to the ssis_admin database role
-
Membership to the sysadmin server role
Note
|
|---|
|
When you have permission to perform an operation on the server, you also have permission to view information about the operation. Row-level security is enforced; only rows that you have permission to view are displayed. |
