Post reply

Transferring data from excel file to sql server 2005 through sql server agent job

  • November 24, 2006 at 4:52 am

    #173610

    hi,

    I am new to sql server 2005 so can anybody help to transfer excel data to sql server 2005 through sql server agent job or dts package.The main task is to transfer lots of excel data to sql server daily.Any other way to do so. pls give me the code or link if possible.

  • November 24, 2006 at 8:21 am

    #673812

    If you create a new dtsx package you can add a dataflow task and in the task there is an "excel" source. you can point it at your excel Spreadsheet and then choose your sql server as the destination..

    Hope this helps!

    Rich

  • November 24, 2006 at 9:57 am

    #673834

    thanxs rich

    i have transfer the excel data to sql server through dts. but now how to execute that dts in sql server agent so  the data of excel file transfer to sql server daily on any particular time.pls reply soon.

  • November 24, 2006 at 10:37 am

    #673840

    Sure.. Create a new job and Go to "Steps" and pick type: SQL Server Intergration services package. Then Pick the server that is hosting the package and then browse for the package. Then you can go into the schedule menu and set up a schedule you would like it to be run at..there are a plathora of settings you need to set up (data sources, ID etc) but this should get you started in the right direction!

    Thanks..

    Rich

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

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