Chapter 19. Introducing the Data Flow Task
IN THIS CHAPTER
“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.
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.