10 tips and tricks for better SSIS performance

2013/11/06 — 5 Comments

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.


David Peter Hansen

Posts Twitter

David Peter Hansen is a Microsoft Certified Master of SQL Server and works as Senior Manager at Hitachi Consulting in London. He has worked with database development and administration for 12 years, and has worked with the Microsoft Business Intelligence platform since SQL Server 2000. He specializes in developer coaching as well as scalable architecture and performance tuning on large-scale data warehouses and BI solutions. He is a frequent speaker at SQL Server and BI conferences.

5 responses to 10 tips and tricks for better SSIS performance

  1. Are you using the Server Broker or a table with some clever tsql code?

    • (for the queue example)

      • 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.

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

Leave a Reply