Thank you for the article Elliott!
I think you will find this related information interesting. CozyRoc has recently released a new third-party commercial task called Parallel Loop Task
. What this task allows is execution of multiple "Foreach Loop Container" iterations in parallel. The setup is very simple:
1. You point to existing loop container that you want executed in parallel.
2. You select how many concurrent threads you want to use for the loop execution.
In tests, a CPU intensive sequential process when executed in parallel on 4-core machine was executed 3 times faster compared to the sequential.
We believe this new task is very powerful tool that can help you use your computer resources in the most efficient way.
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/