Chapter 23. Data Flow Task Internals and Tuning

IN THIS CHAPTER

Data Flow Task Under the Hood

Turnkey Settings for Speedup

An Approach to Data Flow Optimization

“QUICKER THAN A GREASED WEASEL.”—EUAN GARDEN

The Data Flow Task is performant by design such 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 default settings are typically sufficient for most applications and do not require any special tuning. However, large and complex data flow loads bring their own challenges and there are often more trade-offs and decisions that need to be made that the ...

Get Microsoft SQL Server 2005 Integration Services now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.