Helpful information and examples on how to use SQL Server Integration Services.
The Balanced Data Distributor (BDD) transform has updated and released for SQL Server 2012.
The BDD transform makes it easy to split your data flow up on a buffer-by-buffer basis. The two primary scenarios for it are when you want to do parallel inserts into a destination…
… and when you want to parallel work across multiple paths …
More information can be found on the links below:
It is better than today's approaches, but... with a little more thought, it should have been a container that understands parallelization and executes its steps with different data.
Say, end of month processing ... the steps are the same for every account/customer, and could be done for each in parallel.