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.




Comments

Popular Posts

Failed to execute the package or element. Build errors were encountered

Restore of database 'DataBase_Name' failed. (Microsoft.SqlServer.Management.RelationalEngineTasks)