How to Read First and Last Rows from Flat File

Sometime we have to read the first row (Header Row) and last row (Footer 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 three variables as VarFilePath, VarHeader and VarFooter.

Variable Name          Data Type                  Value

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

Personal\ Flat Files\Test_File_8192015.txt

VarHeader                  String

VarFooter                    String

Step 5:

Edit Scrip task.

Step 6:

In bellow window

Ready Only Variables as User::VarFilePath

Read Write Variables as User::VarHeader and User::VarFooter

Step 7:

Click on Edit Script and write a bellow Script.

// TODO: Add your code here

            string FilFullPath = "";

            FilFullPath = Dts.Variables["User::VarFilePath"].Value.ToString();

            string[] lines = System.IO.File.ReadAllLines(FilFullPath);

            Dts.Variables["User::VarHeader"].Value = lines[0].ToString();

            Dts.Variables["User::VarFooter"].Value = lines[lines.Length - 1].ToString();

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

                      + "   Footer: " + Dts.Variables["User::VarFooter"].Value.ToString());

Step 8:

Click ok and execute the task.

Step 9:

Bellow window shows a header and footer lines of the flat file.