Post reply

AUtomate csv file data

  • December 1, 2015 at 6:14 am

    #305713

    Hi ,

    i need to automate on the below

    1.call the webservice link , it will generate one csv file

    2. move csv file data into sql server database

    3. it should run every day and overwrite the existing table data

    Is there anyway to o this ?

  • December 1, 2015 at 6:16 am

    #1843163

    SSIS or a PowerShell task?

  • December 1, 2015 at 9:05 am

    #1843236

    Personally, I avoid SSIS and PowerShell whenever I can, which is "Always" when it comes to SSIS. 😛

    I don't know how you intend to make the CSV file from the WebService but, once done (and make sure it's done right so you have no data anomalies), use BCP or BULK INSERT, possibly with a BCP FORMAT FILE, to very quickly import the data into an expendable table.

    If you have two such tables, you can keep one table online until the other table is loaded and then simply repoint a synonym to bring the other table online and set the other table offline. An advantage here is that if the table import fails for any reason, the old data never went offline and you have some time to fix things.

    --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 3 posts - 1 through 2 (of 2 total)

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