What is the difference between Control flow and Data flow?

Control Flow:

  • Controls the flow of executions in SSIS package
  • It’s Process oriented
  • Smallest unit is Task
  • Made up of Tasks connected with precedence constraints
  • Tasks in Control flow need to be completed before moving to the next task

Data Flow:

  • Transfers the data from source to target
  • It’s Information oriented
  • Smallest unit is Component
  • Made up of Source(s), Transformation(s) and Destination(s)
  • None of the component will wait for other component to work

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.