Post reply

Problem Extracting Data from Flat File

  • December 18, 2007 at 2:33 pm

    #127363

    I am trying to Load data from a flat file onto a table in server. The flat file is sent to us by our clients. Flat file is comma delimmted. Everything of a file is fine until we get to the end. The file has extra account information (account description, and more), which makes the colums too long and the load fails.

    Is there a way in SSIS to stop loading the data from a flat file when it hits a certain point (an error or a certain word)? We usually cleanse flat file by using c#, but it's tedious. Can somebody suggest a better way in SSIS?

    Note: Our client send us all kinda crazy looking flat files, this is one of the ones which is clean, but problem at the end

    Thanks.

    Ravi.

    ------------
    🙂

  • December 18, 2007 at 2:45 pm

    #761237

    I load flat files that have many different row types. Fortunately, they're identified by a key in the file. I just load the whole shootin' match into a wide single column file and split it from there.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • December 19, 2007 at 1:52 am

    #761306

    what is the error you are getting at the end?

    coz if the error is with the destination datatypes then have a data convertion transformation and check it out.

    let me know if it doesn't work

    jagadish

Viewing 3 posts - 1 through 2 (of 2 total)

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