Creating a SSRS report to show SSIS package run time statistics

Geschrieben von Database Magician am Freitag, 29. April 2016

'In most companies developers are restricted from accessing the MSDB database and they rarely know the performance of their packages in a production environment unless they have access to third party software tools or a friendly DBA. This happened to me once when I wanted to know how long my packages ran in a production environment and I had no access to the MSDB database to look at the sysjobs and sysschedules tables. The work around is to enable SQL Server logging in SSIS packages and to create a SSRS report from the sysssislog table.'...

https://www.mssqltips.com/sqlservertip/3628/creating-a-ssrs-report-to-show-ssis-package-run-time-statistics/