Running multiple SSIS Foreach Loops in parallel

11. August 2010 06:00 by Dougbert in   //  Tags: , ,   //   Comments (0)

The Parallel Loop Task, recently released in beta by Cozyroc Software, "can execute multiple iterations of the standard Foreach Loop Container concurrently. In tests, a CPU intensive sequential process when executed in parallel on 4-core machine was executed 3 times faster compared to the sequential." This new task appears in Beta 2 of the Cozyroc package, SSIS+ 1.5.

For more information or to try out the Parallel Loop Task...

See Cozyroc at SQL PASS in Seattle this fall.

-Doug

 

Add comment

  Country flag

biuquote
  • Comment
  • Preview
Loading