10 tips and tricks for better SSIS PErformance

10 tips and tricks for better SSIS PErformance

Your SSIS packages are taking longer than they should, but you are not sure what to do about it. This deck gives you 10 tips and tricks for gaining better performance. You’ll learn not only 10 reasons to why your packages are running slow, but also 10 ways to do something about it. Find out when to use T-SQL instead of SSIS transformations, why you should care about data types, what a blocking transformation is, why buffers are important, and much more.

This talk was given at SQLSaturday #229 Dublin


David Peter Hansen

June 22, 2013