Home Forums Data Warehousing Integration Services Daily CSV import to SQL - How ? RE: Daily CSV import to SQL - How ?

  • September 16, 2014 at 10:53 am

    #1745838

    G-Force (9/16/2014)

    Hi Jeff

    Still trying to find the dummies guide 🙂 . Is there anywhere you can point me to on how to do it in TSQL ?

    Any help gratefully received.

    Thanks

    G

    The basics are to determine if the file is there and then import it using BULK INSERT. I'll see if I can whip up an example for you tonight. In the mean time, can you post the CREATE TABLE statement for the "target" table and (if there's no personal or company private information), attach a file with at least the first 10 lines of data in it (including any headers, etc).

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