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.

Slide Deck 242 KB , MP4 Video Low 67 MB , MP4 Video Med 89 MB , MP4 Video High 208 MB , MP4 Video HD 378 MB