Optimizing and balancing Unit of Work in SSIS with T-SQL and Biml


Ben Weissman

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.

published 09.08.17

last updated 09.08.17




You are not authorized to comment. A verification email has been sent to your email address. Please verify your account.


There are no comments yet.