January 26, 2015 at 9:00 am
I have been trying to read a excel file from SharePoint Library, 32 bit SharePoint 2008, SQL 2012. I'm not sure what else might be needed to determine a solution, I've seen several attempts where they say to paste the shortcut link in the connection manager, but that didn't work.
January 26, 2015 at 9:18 am
The first thing I think of is permissions issue. SSIS is probably not running under an account that has permissions to access the file in Sharepoint.
It's been a long time since I had to deal with Sharepoint, so my experience is with an older version of the product, but in the old sharepoint you could turn on a mode where you could access files in Sharepoint as if it were an SMB share. If you can get that going, SSIS might have an easier time reading it like a traditional file system rather than as a web link. Same issue with permissions will still apply, though.
January 26, 2015 at 9:22 am
Ok, Thank You I will try that.
January 26, 2015 at 4:08 pm
Ok..so who ever setup the SharePoint server didn't set it up where the files are saved in directories, but where the files are just pointers where they are actually saved in SQL DB. So how do I do this, other than having the user to save the file to a shared directory? Thanks in advance.
January 27, 2015 at 4:02 am
The best approach for this is to leave SharePoint as it is. There are good reasons for SharePoint being set up to not save files to a directory.
If you want to access the files in SSIS then use a script task and download the file from the SharePoint site to a local directory. Process as normal and then delete the local file.
There are plenty of examples online on how to download from SharePoint in code.
January 28, 2015 at 5:59 am
I get this error...
Connection manager "Excel Connection Manager": The requested OLE DB provider Microsoft.ACE.OLEDB.12.0 is not registered. If the 64-bit driver is not installed, run the package in 32-bit mode.
So is there a good work around without installing the 64 bit version?
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply