Chapter 23Data Flow Task Internals and Tuning

IN THIS CHAPTER

Image Data Flow Task Under the Hood

Image Turnkey Settings for Speedup

Image An Approach to Data Flow Optimization

The Data Flow Task is performant by design so that out of the box, without any tuning or optimization, the default settings generally deliver great performance. For less-complex data flows—that is, data flows with five or six components with small data loads of a gigabyte or less—the ...

Get Microsoft® SQL Server™ 2008 Integration Services Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.