Post reply

Sharepoint and SQL Server 2005

  • November 19, 2008 at 3:44 am

    #127734

    hello,

    please help me, i want to transfer data from SharePoint web service, those are in Ecxel files in a document library, TO

    SQL SERVER 2005.

    thanks

  • November 20, 2008 at 9:06 am

    #901108

    Sorry, there's way too many ways to look at the request. What do you want to do? Import the data in the sheets to a table? copy the files into the DB? Pull data from sql and use it in the excel files? Link data in the files to sql? What?

  • November 20, 2008 at 9:06 am

    #901110

    I am assuming that this is not a one time push, but you are planning to schedule this as a regular process?

    I would recommend creating your own exe or script file (even using CLR, if you have it enabled) to copy the excel file(s) from the sharepoint virtual location to a physical location on a server. Then you can use SSIS to do a simple import. You might even be able to write the "sharepoint to physical drive" pull within the script task on SSIS.

    Hope this helps!

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

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