9.07.2012

Control Flow vs Data Flow in SSIS

Difference between Control Flow and Data Flow in SSIS


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

No comments:

Post a Comment