July 21, 2014 at 9:45 am
Hi,
I have an ssis package which imports multiple excel files to sql table. I used For loop task and created variables which picks up the excel files dynamically.when i am executing it throws me an error "TITLE: Microsoft JET Database Engine
------------------------------
The Microsoft Jet database engine cannot open the file. It is already opened exclusively by another user, or you need permission to view its data.
Excel version 97-2003
Tried different things like changing the connection string to "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=blah blah;Extended Properties="EXCEL 8.0;HDR=YES";
also search over internet and tried to change the packageproperties-->run64bit to false
and no one opened the file i am using.
please help
July 21, 2014 at 11:20 am
I think the error is pretty clear, another person or process has one (or more) of the files your are trying to process open or the execution context the SSIS process is running in doesn't have permissions on the file(s).
How are you running the SSIS package, in BIDS/SSDT, via DTExec, through a SQL Agent job?
Usually when I've had this happen it is during development and I am running the package in BIDS/SSDT and I had opened the Excel sheet so I could look at the data ahead of time and I forgot to close the document before running the task.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
July 21, 2014 at 11:30 am
Running the ssis package in visual studio 2005.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply