blogs.conchango.com

welcome to the conchango blogging site
Welcome to blogs.conchango.com Sign in | Join | Help
in Search

Browse by Tags

All Tags » SSIS » SQL Server Inte... » ole db source a... » Foreach Loop
  • SSIS: Caching result sets for re-use in a ForEach loop

    Peter (sorry, don't know your surname) made a very good comment here: http://blogs.conchango.com/jamiethomson/archive/2006/02/20/2895.aspx#2903 that data-flows in a ForEach loop carry out repeated SELECTs against a data source and it would be good to be able to cache that data rather than executing the same query over and over. Its a great ...
    Posted to SSIS Junkie (Weblog) by jamie.thomson on February 20, 2006
Powered by Community Server (Personal Edition), by Telligent Systems