August 8, 2008 at 2:10 pm
I have a sql job where in it imports an excel file into sql server, when i run the job i get the following error.
Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft JET Database Engine" Hresult: 0x80004005 Description: "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.". End Error Error: 2008-08-08 13:06:32.89 Code: 0xC020801C Source: Data Flow Task Source - Upload$ [1] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection. The step failed.
It imports excel file when do it through import wizard and when i run the same job in another server it imports file and i am pointing to the same file from both the servers.
August 8, 2008 at 2:16 pm
Are your processes the only ones that touch the spreadsheet?
It sounds like one of the processes is not releasing the file. I think if you use the Import\Export Wizard it doesn't release the file correctly.
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
August 8, 2008 at 2:22 pm
this is the only process accessing the spreadsheet.
August 9, 2008 at 12:32 am
Hi Mike
This error seems that the excel file is been used by some other process apart from ur import task, is this a one off task or are you trying to get something from a file that is been updated by some other process?? if this is the case then you cant import until that process release your file.
🙂
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply