Dougbert.com
Microsoft SQL Server Integration Services and more by Douglas Laudenschlager.

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

 


Posted Aug 11 2010, 11:00 AM by dougbert
Powered by Community Server (Non-Commercial Edition), by Telligent Systems