Designing and Tuning for Performance your SSIS packages in the Enterprise (SQL Video Series):

"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:

• How the limits of the source system affect performance.
• Why disk I/O is important.
• Why you should establish a package performance baseline

'

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:

• Extraction
• Transformation
• Loading

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:

• Demonstration of a simple package that shows you how Integration Services divides the data along the data flow paths and how buffers carry data along those paths.
  This simple package performs the following operations:
  • Data extraction
  • Character mapping
  • Creation of new columns by using a synchronous transformation
  • Multicasting
  • Sorting by using a blocking (asynchronous) transformation.
• Design guidelines for building and maintaining the data flow of a package.

'

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.