SSIS package to load data from Excel sheet on sharepoint to SQL server table giving error when run through SQL jobs

Question

I have create a SSIS package which get data from excel sheet stored on sharepoint and then loads data to SQL server tables.

When the package is run manually on SQL server it runs successfully but when the package is run through SQL job it gives error as below:

Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E4D.
An OLE DB record is available. Source: "Microsoft Access Database Engine" Hresult: 0x80040E4D Description: "Cannot start your application. The workgroup information file is missing or opened exclusively by another user.".

I have checked that the excel sheet is not open and also gave all the rights to user through which the job is run.
Also created a proxy user to run job but still gives same error.

Can anyone please help.

Answer 1

Hi @Anonymous ,

Have you try to run the package in 32bit for a try?

I didn't have the Access environment, I did some online research for you.

Someone mentioned the below steps, you may have a try.

Add a new OLE db connection>new>Microsoft Jet OLE db provider>put the db name in the Database file name and the workgroup login/password in user name & password

then click "All" on the left and stick the workgroup path in "Jet OLEDB:System Database"

Also you may check the protection level of the package.

access-control-for-sensitive-data-in-packages

Regards，

Zoe

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.