Browse by Tags

• dtexec
• IsSorted
• lookup
• Merge Join
• nugget
• OLE DB Destination
• OnPipelineRowsSent
• repost
• script component
• sql server
• ssis
• synchronous components
• video

• Dataflow mechanics [SSIS]

  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 (arguably) valuable content over there however certain events in the past leave me concerned that that content is Read More... Posted Tuesday, October 25, 2011 9:48 AM by jamiet | 11 Comments Filed under: dataflow, repost, sql server integration services, 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: dataflow, OnPipelineRowsSent, repost, sql server, sql server integration services, ssis

• Why is there no CROSS JOIN component in SSIS?

  I saw an interesting question on the SSIS MSDN forum yesterday where someone was asking how to do a cartesian product (i.e. a CROSS JOIN) in a SQL Server Integration Services (SSIS) dataflow. Links were provided to various articles that cover this (see Read More... Posted Friday, July 8, 2011 11:02 AM by jamiet | 4 Comments Filed under: dataflow, sql server integration services, ssis

• Merge Join component sorted outputs [SSIS]

  One question that I have been asked a few times of late in regard to performance tuning SSIS data flows is this: Why isn’t the Merge Join output sorted (i.e.IsSorted=True)? This is a fair question. After all both of the Merge Join inputs are sorted, hence Read More... Posted Monday, January 31, 2011 8:40 PM by jamiet | 4 Comments Filed under: dataflow, IsSorted, Merge Join, sql server integration services, ssis

• 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: dataflow, dtexec, sql server, sql server integration services, ssis

• 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: dataflow, sql server, sql server integration services, ssis

• 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: dataflow, script component, sql server, sql server integration services, ssis

• SSIS gotcha: Beware of multiple outputs from a synchronous script component

  A few days ago I was alerted to a peculiarity of SSIS’s Script Component that I believe people need to be aware of. Its a peculiarity that can rear its head when your script component is synchronous and has multiple outputs . Here’s an example of a dataflow Read More... Posted Sunday, July 4, 2010 10:43 PM by jamiet | 1 Comments Filed under: dataflow, nugget, sql server integration services, ssis, synchronous components, video

• Inequality joins, Asynchronous transformations and Lookups : SSIS

  It is pretty much accepted by SQL Server Integration Services (SSIS) developers that synchronous transformations are generally quicker than asynchronous transformations (for a description of synchronous and asynchronous transformations go read Asynchronous Read More... Posted Friday, May 14, 2010 11:13 PM by jamiet | 16 Comments Filed under: dataflow, lookup, Merge Join, sql server integration services, ssis, video

• Destination Adapter Comparison : SSIS Video Nugget

  In this, my latest video nugget, I demonstrate and compare three ways that you can insert data into a SQL Server table from the SSIS DataFlow: OLE DB Destination without Fast Load OLE DB Destination with Fast Load SQL Server Destination The demo peels Read More... Posted Tuesday, March 2, 2010 8:11 AM by jamiet | 5 Comments Filed under: dataflow, nugget, OLE DB Destination, sql server integration services, ssis, video