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.
SELECT [statistics_id]
,[execution_id]
,[executable_id]
,[execution_path]
,[start_time]
,[end_time]
,[execution_hierarchy]
,[execution_duration]
,[execution_result]
,[execution_value]
FROM [SSISDB].[internal].[executable_statistics]
|
It store the execution duration. Here we can get the
executing time of the package. The length of time the executable spent in
execution. The value is in milliseconds.
Execution Result
The following are the possible values:
Ø
0 (Success)
Ø
1 (Failure)
Ø
2 (Completion)
Ø
3 (Cancelled)
