tush002sunny (7/4/2012)
I have the records in my flat file as below :HDR123495968908
1111023456712345
1234567890098007
TRL4567897593494
After the use of derived column I am able to map certain characters to the particular column of database table.
Now while mapping to the database table I want to skip these header & trailer row.
Data present in the SQL server table like this:
column1 column2
1111023 456712345
1234567 890098007
HDR1234 495968908
TRL4567 897593494
Will you Plz help me out for this doing in SSIS Package Transformation.........?
Thanks...............!!!!
One way is to use a conditional split. Check character one of the input data, and if it is H or T, redirect the row to a different output (which you do not need to use). That will effectively discard these rows.