THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » SQL Server Inte... » lookup » ssis   (RSS)
  • 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 and synchronous data flow components). Notice I said “generally” and not “always”; there are ...
    Posted to Jamie Thomson (Weblog) by jamiet on May 14, 2010
  • 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 Lookup component; I rattled off some comments and figured it would be prudent to drop some of ...
    Posted to Jamie Thomson (Weblog) by jamiet on March 18, 2010
Privacy Statement