SSIS 2012 logging and monitoring

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
  • Downloads
    Slide deck available Slide Deck 700 KB
    Video available MP4 Video Low 186 MB
    Samples available Demo Code 75 KB
    Video available MP4 Video Med 186 MB
    Video available MP4 Video HD 514 MB
  • SpeakerBIO
    Peter ter Braake, SQL Server MVP and MCT, co-founder of the Dutch PASS Chapter and organizer of the Dutch SQL Saturday, teaches SQL Server since 2002. Teaching is for Peter the perfect opportunity to share his SQL Server knowledge and his enthusiasm for the product. Since 2008 he works as an independent contractor giving him the opportunity to use his classroom experience in the real world and use his real world experience in the classroom.
  • Video