Post reply

Urgent Help

  • June 17, 2009 at 1:13 pm

    #95665

    Hi

    I am new to sql server but have a background in IBM DB2.

    I have to create a SQL Server job which pics up a .csv file and updates data from it in a sql table.The job has to run weekly.

    I have no clue how to proceed.

    Can someone pls give a step by step guideline & Resources I can use to do this work.

  • June 17, 2009 at 2:32 pm

    #1011277

    You could check the following thread. It covers a variety of options how to import Excel files including several more links.

    http://www.sqlservercentral.com/Forums/FindPost326846.aspx

    If the Excel file always has the same location, file name and structure I would connect it as a linked server and treat it like a table.

    A thread covering this option:http://www.sqlservercentral.com/Forums/FindPost443898.aspx.

    Once you're at the point to have the table connected and your update statement works, add a new job using SSMS (Management Studio) and put the update statement in the query window. Ading a job via SSMS is pretty much self-descriptive from my point of view.

    Another way of adding a job is using T-SQL. For details please have a look at BOL (BooksOnLine = SQL Server Help file accessible via {F1} from SSMS).


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

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

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