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