Post reply

FLat file Normalization

  • July 19, 2007 at 3:31 am

    #120756

    Hi Can Any one help,

    Well i got a flat file (in{CR}{LF} format) and needs to be imported into a sql server 2000.

    now i need to know how can i create a package using DTS or some thing which kindoff breaks the data down and insert it into appropriate tables from the flat file. I need to find a way to carry it out in one process as the data is imported through the pipe. SO i have multiple tables which would eventaully contain the data from flat file.So ill Be getting the Data after every two weeks which will need to be imported into SQL server 2000. So is there any way i can automate the process.

    regards

  • July 19, 2007 at 8:49 pm

    #720983

    Duplicate post...

    http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=145&messageid=383148

    --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)

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

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