SSIS, SSAS and SSRS(MSBI) interview questions: – Explain Data Flow Tab and Data Flow Task in SSIS?

When we think about creating any SSIS package, after we open the SQL server data tools or Business Intelligence development studio we will landed into SSIS designer window.

As you can see SSIS designer contains many tabs at the top. Work will always start with Control Flow. In control flow we add different kind of tasks to achieve different functionalities. One of those task is Data Flow Task which will let us define our ETL Process.

Just take Data Flow task from toolbox and drag into the Control Flow tab area. Now double click the task and it will take us to Data Flow tab.

Data Flow let us define the flow of data from source to destination.

What all components we can add in Data Flow Tab?

There are three types of components which we can add in Data Flow tab.
Sources – Let us define the source repository from which data is going to be fetched.
Transformations – Let us convert or modify the data retrieved from source as per business requirement.
Designations – let us define the destination repository where data will be transferred.

What will be used in Data Flow tab to show the Flow of data?

We use the green arrow coming out of source and transformation components. This green arrow is termed as Data Flow Path.

If you are looking for a step by step article on Microsoft Business Intelligence you can start from here.

For technical trainings on various topics like WCF, MVC, Business Intelligence, Design Patterns, WPF and UML and many more feel free to contact or visit

For more stuffs like this click here. Subscribe to article updates or follow at twitter @SukeshMarla

Also see another SSIS, SSAS and SSRS(MSBI) interview questions video on basics of SSIS , SSAS and SSRS: –


About c# and .NET Interview questions

This blog is for developers who want to crack .NET and C# interviews. It has all tips and tricks needed to crack .NET interviews , C# interview , SQL Server interview , Java interview , WCF Interview , Silverlight interview , WPF interview , LINQ interview , Entity framework Interview. Do not forget to watch our Learn step by step video series. Learn MVC in 16 hours:- Learn AngularJS Step by Step:- Learn Design Pattern in 8 hours:- Learn C# and .NET in 60 days:- Learn MSBI in 32 hours:- Learn SharePoint Step by Step in 8 hours:-
This entry was posted in Uncategorized and tagged , , , , , , , , , . Bookmark the permalink.

One Response to SSIS, SSAS and SSRS(MSBI) interview questions: – Explain Data Flow Tab and Data Flow Task in SSIS?

  1. Pingback: Tabs in the SSAS cube designer | Just Compile

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s