Package execution reports
Once the SSISDB has been created, package execution reports can be accessed from SSMS by right clicking on the Integration Services Catalog node:
A typical SSIS package report can be seen in the following screenshot and allows detailed drill-through into the performance and error message levels:
One really neat feature is that you can now see at a glance if an ETL job is taking longer than expected with an easy-to-read graph of the last 10 package execution times:
Get What's New in SQL Server 2012 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
