Executable Statistics table in SSISDB

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)