SQLBits 2010

SSIS Dataflow Performance tuning

Need to eek out a bit more oomph from your dataflows. This session might be of some use.
Buiding highly performant data flows takes more than just dragging a few boxes onto the design surface and wiring them up. In this session I'll talk about SSIS's buffer architecture, synchronous and asynchronous transformations, performance tuning knobs and, most important of all, designing for performance.