O'Reilly logo

Microsoft SQL Server 2005 Integration Services by Kirk Haselden

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required