Different between Control Flow and Data Flow.

a. Control flow is for designing the flow of the package. Data flow is for ETL process.

b. Data Flow is the subset of control flow

c. There will be only one control flow while multiple dataflow can exists.

d. Data flow cannot work without a control flow

All process based tasks are part of control flow while ETL related tasks are the part of Dataflow which is again a subset of control flow.

Asked on February 13, 2016 in SSIS.
Add Comment
0 Answer(s)

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.