SSIS Package Execution Error

Question

Hi everyone,

Here's what I'm trying to do:

1 I scheduled a job in SSMS to refresh my table.

2 Then I need to export the table to the Excel file in company's share folder so that everyone in my team can view the data.

3 I built a SSIS package in Visual Studio to export the table from SQL to Excel (drop table - create table - load data). It works fine in Visual Studio.

4 Now I want to schedule the SSIS package as well. Thus I deployed the SSIS package to Integration Services Catalogs.

5 But when I execute the package, it shows the following error:
Error: 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 '\*** *** ***.xls '
It is already opened exclusively by another user, or you need permission to view its data.".

Does anyone have any advice? I'm sure no one was having the file opened. If that's the permission issue, how can I fix that?

Do I need to change anything in Configure?

Any help would be appreciated!!

Thanks

Answer 1

Hi @Jay Jiang ，

It is already opened exclusively by another user, or you need permission to view and write its data."'

Check the permission of the account which you are using to run the agent job.

Make sure the account has the enough permission to write data to the excel file.

You may also consider to use proxy account to run the job and give the permission.

Details you may refer to running-a-ssis-package-from-sql-server-agent-using-a-proxy-account.

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.