December 13, 2013 at 4:01 am
I've set up an SSIS package to import a rake of Excel files as a 'one off' upload. I've used a For Each loop to go through the folder containing the files and yesterday it worked fine. I've subsequently made a couple of minor changes and now the filename variable doesn't seem to be working. When I attempt to run the package using the loop I get:
"The Microsoft Jet database engine cannot open the file 'C:\....'. It is already opened exclusively by another user, or you need permission to view its data".
When I run the package for each file individually it works as it should. Can anybody shed any light on this please? If you need any more information please just ask.
Thanks.
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
December 13, 2013 at 4:14 am
Is there a chance that anyone (or even you) has one of the files open in Excel?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
December 13, 2013 at 4:20 am
Phil Parkin (12/13/2013)
Is there a chance that anyone (or even you) has one of the files open in Excel?
Thanks Phil, that was the first thing I thought but no. I'm working locally, the files are sitting are sitting in a folder on my desktop and I've not even got Excel open, let alone the files.
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
December 13, 2013 at 9:21 am
Between loops you might add like a second or two delay, I've seen some locking of the file resolve itself this way..
CEWII
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply