Difference Between Control Flow and Data Flow in SSIS - MSBI

Freshers Junction provides all the technical interview questions and Latest Jobs Information.

                Now the Our Technical Interview Question is “What is the difference Between Control Flow and Data Flow in SSIS – MSBI”. Freshers and Experienced Candidates note that this is very first question asked you to in the Technical Interview (If you are on SSIS – MSBI platform).

First Difference Between Control Flow and Data Flow in SSIS:

                First Difference between Control Flow and Data Flow in SSIS is “Control Flow is a Process Oriented and Data Flow is Data Oriented”

Second Difference Between Control Flow and Data Flow in SSIS:

                Second Difference between Control Flow and Data Flow in SSIS is “Control Flow Have Tasks and Container, Data Flow have source, transformations and Destination”

Third Difference Between Control Flow and Data Flow in SSIS:

                Third Difference between Control Flow and Data Flow in SSIS is “In control flow connections made up through Precedence constraint, In Data flow connections made up through paths”

Fourth Difference Between Control Flow and Data Flow in SSIS:

                Fourth Difference between Control Flow and Data Flow in SSIS is “Smallest unit in the control flow is Task, Smallest unit in the data flow is Component”

Fifth Difference Between Control Flow and Data Flow in SSIS:

                Fifth Difference between Control Flow and Data Flow in SSIS is “output for control flow is Success, Failure, Completion but in Data flow output is not fixed”

Note: data flow is a part of Control Flow, in the following image you can see data flow and control flow

Control Flow

These are the main Differences between control flow and Data flow in SSIS – MSBI. If you have any queries related to this topic then comment here, we are here to help you. OR if you know any more differences also comment here, then that will be helpful to some others.

DataFlow

You may also search in Google as:
Main differences between Control Flow and Data Flow in SSIS, what are the differences between Control Flow and Data Flow in SSIS. Control flow and Data flow in SSIS etc.