September 8, 2010 at 10:33 am
Hi everybody,
I am trying to build SSIS package to loading the excel file from sharepoint site. I used UNC to connect the file ; it is succesfully. However, when I click Name of excel sheet in excel sheet editor, it gives me below message. Can anybody help me with the issue. Thanks a lot !!
microsoft office access database engine cannot open or write to the file. it is already opened exclusively by another user,or you need permission to view and write its data
September 15, 2010 at 2:59 pm
I am a SharePoint Admin troubleshooting this iss for a DBA on my team. Have you been able to get this working?
September 21, 2010 at 9:28 am
(without knowing much about sharepoint...)
sounds like a permissions issue
how about copying it to a local temporary directory and then connecting?
September 21, 2010 at 9:44 am
I found the resolution to this. I had to change the library that the file was stored in and the name of the file itself so that there were no spaces in the path.
Once I did this it began to work.
September 23, 2010 at 3:55 am
Can you more specific. what is library you changed? Thanks
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply