Building Integration services packages is one. Creating a monitoring solution for all packages and ETL processes is something different. Good monitoring however can be a live safer, or  may be it is simply part of your functional specs.
In this session we will recap how logging worked in SSIS 2008. We will then discuss some of the features introduced in 2012 and the benefits of project deployment. We will dive into the SSISDB catalog views and discuss pro’s and con’s of the available views. We will add our own logging to packages to extend the out-of-the-box logging available in SSIS 2012. We end this demo-only session by building a simple SSRS report on top of the logging we build/configured for our packages.
Presented by Peter ter Braake at SQLBits XI
Slide Deck 700 KB
MP4 Video Low 186 MB
Demo Code 75 KB
MP4 Video Med 186 MB
MP4 Video HD 514 MB