Control Flow vs Data Flow in SSIS

Difference between Control Flow and Data Flow in SSIS

Control Flow
Data Flow
The smallest unit in Control Flow is called task.
The smallest unit in Data Flow is called component.
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.

No comments:

Post a Comment