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];