Logging and Reporting Patterns - SQL Server Integration Services Design Patterns - page 384

Using the Existing Reports
Our next design pattern is an important one: use what is provided to you. Included in
the SSIS Catalog are reports that use the logging information we have just discussed.
The information in these reports includes an in-depth view of all of your packages' ex-
ecutions. These reports are a great start for you to see when your packages run, if any
errors occur, and potential trouble areas for you to investigate.
Figure 15-8 shows all of the reports available to you. You can access all reports
through the Management Studio interface and the Integration Services Catalog node.
Figure 15-8 . Available catalog reports
If you are looking at a specific execution, you will always want to start with the
Overview report, which can be run by selecting the Overview link on any of the
provided reports. In fact, at the end of an execution through the interface, you will be
asked if you want to see this report. If you select yes, you will see something similar to
Figure 15-9 .