SSIS Dataflow Performance tuning
In this session I'll demonstrate that SSIS perf tuning is less about fine-grained tweaks and more about designing packages correctly in the first place.
We'll cover the pre-requisites like synchronous/asynchronous components and the execution trees that they result in.
Following that I'll demonstrate how, armed with this knowledge, dataflow performance tuning is all making intelligent choices during your package design. Demos will include a comparison of Merge Join and Lookups, strategies for loading from flat files and splitting work over multiple components.
Lastly I'll show you a little known "go faster" switch that you can use when loading data from text files.