SSIS has been around for some 14 years now, but how it works hasn't really changed, and neither have the use patterns that we see. The flexibility of SSIS is one of its greatest features, but also one of its greatest failures - some patterns and use cases actually prevent your ETL from performing as well as it should. Join us for an explanation of why that is, what you can do about it. We'll even dissect a gnarly package, and reduce its runtime from 15 hours + to a matter of seconds !
Presented by Richard Munn at SQLBits XVIII
Slide Deck 598 KB