Optimizing and balancing Unit of Work in SSIS with T-SQL and Biml
Have you ever run into the situation, where you logically could run all of your load tasks in SSIS in parallel but the system (source or target) would not support it physically? Then you probably ended up organizing your dataloads into multiple groups, aiming for ideally equally sized containers. Doing that manually is a time consuming issue – and it never ends as the timings of your data loads will constantly change. This post is about showing you, how you can easily you can automate the assignment of your tables to containers using simple T-SQL as well as about automating the load package using Biml.
last updated 09.08.17