Post reply

SSIS Flat File as Source and SQL Server As destination

  • July 4, 2012 at 5:42 am

    #1508729

    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.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

Viewing post 16 (of 15 total)

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