Wednesday, December 22, 2010

Control Flow VS Data Flow in SSIS(ZT)

From http://www.bidn.com/blogs/BradSchacht/ssis/305/control-flow-vs-data-flow

Control Flow:

  • Process is the key:  precedence constraints control the project flow based on task completion, success or failure
  • Task 1 needs to complete before task 2 begins
  • Smallest unit of the control flow is a task
  • Control flow does not move data from task to task
  • Tasks are run in series if connected with precedence or in parallel
  • Package control flow is made up of containers and tasks connected with precedence constraints to control package flow

Data Flow:

  • Streaming
  • Unlink control flow, multiple components can process data at the same time
  • Smallest unit of the data flow is a component
  • Data flows move data, but are also tasks in the control flow, as such, their success or failure effects how your control flow operates
  • Data is moved and manipulated through transformations
  • Data is passed between each component in the data flow
  • Data flow is made up of source(s), transformations, and destinations.

Hopefully this will help you understand the differences between the control and data flows.

0 Comments:

Post a Comment

<< Home