July 4, 2012 at 5:42 am
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.
Viewing post 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy