Browse by Tags

• dataflow
• Merge Join
• sql server
• sql server integration services
• ssis
• 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 | 15 Comments Filed under: sql server integration services, ssis, video, dataflow, lookup, Merge Join

• SSIS Lookup component tuning tips

  Yesterday evening I attended a London meeting of the UK SQL Server User Group at Microsoft’s offices in London Victoria. As usual it was both a fun and informative evening and in particular there seemed to be a few questions arising about tuning the SSIS Read More... Posted Thursday, March 18, 2010 10:11 PM by jamiet | 5 Comments Filed under: sql server, sql server integration services, ssis, lookup