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.