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 19. Introducing the Data Flow Task

IN THIS CHAPTER

Pipeline Philosophy 101

Data Flow Terms

Data Flow Properties

“IT’S ALL JUST BOXES AND LINES.”—BRIAN CHRISTIAN

On its face, the Data Flow Task looks much like workflow in a package. It’s all just boxes and lines. You drop components (boxes) onto the surface and then create paths (lines) between them. But that’s where the similarity ends. Whereas workflow is a coordinated sequence of atomic units of work possibly executing in parallel, data flow is a set of sequential operations on streaming data necessarily executing in parallel. Workflow executes a task once and moves on (loops excluded), whereas data flow operations process data in parallel until the data stream terminates.

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