We are getting the fix length flat file which having the Header & Trailer row. Header Row is having the Date and the Trailer Row is having the Rows counts. Date and Row Counts are in the fix place.
Below is the file
Date is staring
from (22,8) and row count is staring from (42,5).
We are
taking the script task to read the Header & Trailer record and from both
line we are subtracting the date and count.
Taking below variables to store the file_path,Row_count and File_date.
Passing these
value in script task.
In script
task we are writing the below code.
|
public void Main() { // TODO: Add your code here //User::File_date,User::File_path,User::Row_count string header = "HEADER"; string trailer = "TRAILER"; string textFile = Dts.Variables["User::File_path"].Value.ToString(); string[] lines =
File.ReadAllLines(@textFile); foreach (string line in lines) { if (line.Contains(header)) { Dts.Variables["User::File_date"].Value=
line.Substring(22, 8);
} if (line.Contains(trailer)) {
Dts.Variables["User::Row_count"].Value = line.Substring(42, 5); } } Dts.TaskResult
= (int)ScriptResults.Success; } |
Now we can
use this variable where we need.
We are
taking one more script task to see the value.
Below is the
code.
|
public void Main() { // TODO: Add your code here
MessageBox.Show("File date : "+Dts.Variables["User::File_date"].Value.ToString()+" Number of rows
: "+Dts.Variables["User::Row_count"].Value.ToString()); Dts.TaskResult
= (int)ScriptResults.Success; } |
Our package
looks like as below.
Now running
this package.
Get the
expected result.
Thanks for
reading J
