Andy Brownsword doesn’t want any blockers:
We have a platter of transformations to use when constructing data flows in SSIS packages. Not all transformations are equal though, and some can catch us out with performance impact as data volumes scale.
In this post we’ll look at blocking transformations which can trip us up if we’re not careful with them (or avoid them).
Click through for some examples of blocking transformations, as well as some tips on how to manage them.