How to Read First (Header Row) Row from Flat File

Sometime we have to read the first row (Header Row) from flat file. By using Script Task to read a Header Line of flat file.

Step 1:

Open Microsoft Visual Studio and create a new SSIS project (Ctrl + Shift + N).

Step 2:

In Control Flow window, Drag and Drop a Script task.

Step 3:

I have a flat file as shown in bellow.

Step 4:

Create a two variables as VarFilePath and VarHeader.

Variable Name          Data Type                  Value

VarFilePath                 String                          C:\Users\challaba\Desktop\Newfolder\

Personal\ Flat Files\Test_File_8192015.txt

VarHeader                  String

Step 5:

Edit Scrip task.

Step 6:

In bellow window

Ready Only Variables as User::VarFilePath

Read Write Variables as User::VarHeader

Step 7:

Click on Edit Script and write a bellow Script.

// TODO: Add your code here

Using (StreamReader r = new StreamReader (Dts.Variables ["User::VarFilePath"].Value.ToString()))

            {

                Dts.Variables ["User::VarHeader"].Value = r.ReadLine();

                MessageBox.Show(Dts.Variables["User::VarHeader"].Value.ToString());

            }

          

                                    Dts.TaskResult = (int)ScriptResults.Success;

Step 8:

Click ok.

Step 9:

Right click on Script Task and execute it.

Step 10:

Bellow window shows a header line of the flat file.