SSIS Flat File as Source and SQL Server As destination

  • 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 15 total)

You must be logged in to reply to this topic. Login to reply