They have provided you a .txt file and showed you the database table in which this file has to be loaded. They already open the SQL Server Integration Services project so you can create your SSIS Package.
Great , Piece of Cake;). Easy question. So you sit and start working on SSIS Package.
What! I do not see Data Flow Task under Control Flow Items :( Maybe it has moved up or down. You searched over and over but could not find Data Flow Task. You can load the file by using Script Task but that is also not available.
Maybe there is something missing in this SSIS Package. Let's create a new SSIS Package. Oh no, I still do not see those Items in Control Flow Items.
Your interviewer was trying to be smart and has deleted these Items from Control Flow Items list. So how we can bring them back?
As we want to bring the Data Flow Task and Script Task , we need to reset the Toolbox as shown above.
If we have added third party Components or Tasks in our Toolbox then those will be removed. Click "How to Add Third Party Components or Tasks in SSIS Toolbox". For now we can reset to Default.
If you would like to see all the Tasks in Grid, Right click on Control Flow Items and then unchek the List View property.