SQL Centre of Excellence

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 doh!!

See this connect item for more details

http://connect.microsoft.com/SQLServer/feedback/details/724862/onpipelinerowssent-not-logged-by-dtexec

blog comments powered by Disqus