Browse by Tags

• dtexec
• OnPipelineRowsSent
• repost
• script component
• ssis

• [SSIS] OnPipelineRowsSent event

  Once upon a time I blogged at http://consultingblogs.emc.com/jamiethomson but that ended in August 2009 when I left EMC. There is a lot of valuable content over there however certain events in the past leave me concerned that that content is not well Read More... Posted Friday, August 19, 2011 1:48 PM by jamiet | 6 Comments Filed under: sql server, sql server integration services, ssis, dataflow, OnPipelineRowsSent, repost

• Always use dtexec.exe to test performance of your dataflows. No exceptions.

  Earlier this evening I posted a blog post entitled Investigation: Can different combinations of components effect Dataflow performance? where I compared the performance of three different dataflows all working to the same overall goal. I wanted to make Read More... Posted Wednesday, January 12, 2011 10:51 PM by jamiet | 6 Comments Filed under: sql server, sql server integration services, ssis, dataflow, dtexec

• Investigation: Can different combinations of components affect Dataflow performance?

  Introduction The Dataflow task is one of the core components (if not the core component) of SQL Server Integration Services (SSIS) and often the most misunderstood. This is not surprising, its an incredibly complicated beast and we’re abstracted away Read More... Posted Wednesday, January 12, 2011 9:28 PM by jamiet | 6 Comments Filed under: sql server, sql server integration services, ssis, dataflow

• Don’t turn the dataflow into a cursor [SSIS]

  I saw a thread on the SSIS forum today that went something like this: I have the following dataset: AccountNo Date DailyMovement 00000001 28/08/2010 10 00000001 29/08/2010 5 00000001 30/08/2010 7 00000002 28/08/2010 8 00000002 29/08/2010 6 for which I Read More... Posted Tuesday, August 31, 2010 11:22 PM by jamiet | 9 Comments Filed under: sql server, sql server integration services, ssis, dataflow, script component