SSIS execution log

SELECT TOP 1000 [execution_id]

,[folder_name]

,[project_name]

,[package_name]

,[reference_id]

,[reference_type]

,[environment_folder_name]

,[environment_name]

,[project_lsn]

,[executed_as_sid]

,[executed_as_name]

,[use32bitruntime]

FROM [SSISDB].[internal].[executions]

–ssis log

;with DetectedPackages as (

select source, s.executionid

from dbo.sysssislog as s

where event = ‘PackageStart’

group by source, s.executionid

)

–then we use those executionids to display results

select * from dbo.sysssislog as s

join DetectedPackages dp on s.executionid = dp.executionid

where dp.source = ‘PackageName’

–ssis log table

SELECT

[event]

,[computer]

,[operator]

,[source]

,[starttime]

,[endtime]

,[message]

FROM msdb.[dbo].[sysssislog];