SSIS Package running status

 

Use SSISDB

GO

select

    execution_id

    , folder_name

    , project_name

    , package_name

    , environment_name

    , executed_as_name

    , start_time

    , end_time

    , CASE status WHEN 1 THEN 'Created'

        WHEN 2 THEN 'Running'

        WHEN 3 THEN 'Cancelled'

        WHEN 4 THEN 'Failed'

        WHEN 5 THEN 'Pending'

        WHEN 6 THEN 'Ended Unexpectedly'

        WHEN 7 THEN 'Succeeded'

        WHEN 8 THEN 'Stopping'

        ELSE 'Completed' END AS Status

    , caller_name

    , process_id

    , server_name

from internal.execution_info