SQL Interview Questions

SSIS : What is difference between Control Flow and Data Flow in SSIS ?

Difference between Control Flow and Data Flow in SSIS are as follows :

  1. The smallest unit in Control Flow is task whereas smallest unit in Data Flow is component
  2. In Control FLow , Tasks require completion (success, failure or completion) before moving to next task. In Data Flow , one component will not wait for other component to finish, all of them will work together in processing and managing data in streaming way.

Leave a Reply