March 8, 2017 at 10:26 pm
Hi ,
How to read the excel file in sharepoint and store excel data in SQL server database
there are multiple excel files are placed in sharepoint say regionwise.
NA ,APAC ,EMEA
there are some 20-30 excel files are there in each region
Goal is to
1. Read each excel file and store them in SQL server 2014 database.
2.After reading, moving those files to Archive directory of same sharepoint. (in general this can be done through Foreachloop container, but not sure how to do in sharepoint)
mysharepoint url will be looking like http://www.myorg.sharepoint.com/sites/NA/forms/allitems.aspx
getting error when tried with Odata source as "The remote server returned an error"
on searching i found below link but it is not having any aspx page
--https://www.mssqltips.com/sqlservertip/3220/using-the-new-odata-source-in-sql-server-integration-services/
Could you please suggest any option or links
Thanks in advance for your help.
March 10, 2017 at 9:22 am
At least have a read of this link:
Not sure if that will help, but it may at least point you in the right direction. I've never tried to use Sharepoint as any kind of data location, so I had to Google it...
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply