Design patterns for SSIS Performance

Do you wonder about SSIS performance? Well I do, and I've compiled my research into this session. We'll cover various design patterns for solving common problems like inserts vs. updates, is it faster to use a lookup, or can you just catch the errors and process them afterwards? As well as the richer patterns we'll look at some straight comparisons between two components that can be used to do perform the same task and ask which one is quicker?
Presented by Darren Green at SQLBits VI
  • Downloads
    Slide deck available Slide Deck 84 KB
    Video available WMV Video 142 MB
  • SpeakerBIO
    Darren is an independent consultant specialising in data solutions with SQL Server. Having been working with SQL Server from 6.5 onwards he has extensive experience in many aspects of SQL Server, but now focuses on solving problems with SQL Server and SSIS.
  • Video