For all of those whom are interested in SSIS performance, we have posted a new SQL video series about how to design and tune your SSIS packages for performance.
Measuring and Understanding the Performance of Your SSIS Packages in the Enterprise (SQL Server Video) Link | Watch this video
Author: Denny Lee, Microsoft Corporation
This video demonstrates how to measure and understand the performance of packages, based on lessons learned from enterprise customers. In this video, you will learn the following guidelines for improving performance:
Tuning Your SSIS Package Data Flow in the Enterprise (SQL Server Video) Link | Watch this video
Author: David Noor, Microsoft Corporation
This video demonstrates how to improve the performance of the data flow in an Integration Services package. In this video, you will learn how to tune the following phases of the data flow:
You can apply these performance tuning tips when you design, develop, and run the data flow.
Understanding SSIS Data Flow Buffers (SQL Server Video) Link | Watch this video
Author: Bob Bojanic, Microsoft Corporation
This video looks at the memory buffers that transfer data to the data flow of an Integration Services package. The video includes the following items:
Designing Your SSIS Packages for Parallelism (SQL Server Video) Link | Watch this video
Author: Matt Carroll, Microsoft Corporation
This video demonstrates how to increase the performance of your Integration Services packages by designing for parallelism.
Video Acknowledgements Thank you to Thomas Kejser for contributing to the material for the series, SSIS: Designing and Tuning for Performance SQL Server Video Series.
Thank you to Carla Sabotta and Douglas Laudenschlager for their guidance and valuable feedback.
Pingback from SQLCAT SSIS Performance Tuning Videos - SSISBI.com
This post is coming a little late (these have already been announced here and here ), but incase you
Pingback from Tutorial: SSIS Performance Videos | Coded Style
Are the slide decks available for download? If so, where are they?
I would skip the third video until a revision is deployed which explains how to use the features showcased in the video.