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
{
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
Post a Comment
Hi User,
Thanks for visiting My Blog and please provide your valuable feedback and subscribe for more updates. Please don't post any spam content or comments.
Thank You