On of the best events in SSIS is “OnPipelineRowsSent” as this gives you performance data on how many rows are flowing through buffers and is great for performance analysis. Unfortunately I just found out the hard way that while it worked in SQL 2005 and 2012 it does not fully work in SQL 2008R2. Big … Continue reading OnPipelneRowsSent not logged in SQL 2008R2
Just announced is that Matt Masson is to deliver a WHOLE Day seminar as part of the SQL Saturday event I am helping organise with the Dublin SQL Users group. Matt is a developer on the Microsoft SSIS Product Team in Redmond, and is coming all the way from Canada! This will be cover a number … Continue reading SSIS Design Patterns– A seminar not to miss!