July 13th, 2011 
I will be presenting at the next Atlanta Microsoft BI user group. Monday, July 25th, 2011. http://atlantabi.sqlpass.org/ Topic: SSIS Logging and Auditing Framework Level: Beginer / Intermediate Meeting Place Matrix Resources 115 Perimeter Center Place Suite 250 (South Terraces Building) Atlanta, GA 30346 Overview: Proper logging in your SSIS packages can help save hours in [...]
Posts Tagged ‘logging’
Avoiding dups when querying sysssislog
Last year I blogged about Avoiding dups in Parent Packages, when using custom logging. Todd McDermind has a good post on how to query the sysssislog table, if you are using the built in SQL SSIS logging. http://toddmcdermid.blogspot.com/2011/04/transforming-ssis-sysssislog-entries.html
Customize SSIS Logging – Avoid dups in Parent Packages
I have been using a basic set of custom logging for my SSIS packages for a while now. I based my auditing framework on Project REAL and I have expanded it from there. I use event handlers for error, control flow tasks and variable value changes. One problem that I have come across is that [...]
Posted in SSIS 
Tags: logging, Microsoft, parent package, SourceParentGUID, SQL 2008, SSIS, variable 
Comments Off