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 session gave 10 tips and tricks for gaining better performance. 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 were given at SQLSaturday #228 Cambridge, SQLSaturday #229 Dublin, SQLRally Nordic 2013 and SQLRally Amsterdam 2013.

 

Comments

      • says

        I usually just use a table as a FIFO queue, and then a stored proc to pop from the queue. Think Service Broker would be overkill for this. Have thought about doing it in C# instead, as e.g. a custom component. But haven’t got around to do so.

  1. Paul says

    Peter – Really enjoyed the presentation last night. Helped add a few more weapons to my armoury. Cheers

Leave a Reply