Aug
11
2010

Running multiple SSIS Foreach Loops in parallel

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