Unexpected Termination - SQL Agent - excel Import

Question

Hi experts,
According my research over google, this issue has been active since 2018. Unfortunetally I haven't found the right answer.
I hope somebody could help me.

I have a package in SSIS which loads an Excel file data into a Table.
At the same time we have two servers, the development and productiv system.

The same package I deployed it to both servers. In both servers in Management Studio I set a job (exactly) the same.

If I run the package in Visual Studio it runs perfectly with no errors at all.
I execute the job in development system and runs perfectly.
But, in productiv system breaks the process with "Unexpected Termination". I noticed (100% sure) it is while importing the data from the excel file.

My dev-sys has something that my prod-sys doesn't.
How can I find out this difference?

The AccessDatabase Engine is already install (and the sameone) in both environments.

What else can I check or fix?

I am running SQL Server 2017 Ver 14.0.3238.1 in Prod-sys and 14.0.1000.169 in Dev-sys

Thanks in advance.

Alex

Answer 1

Hi Alex,

1.Please check if the user in the job has correct permission to the excel file;
2.Please check if the excel file is open or used by other progress;
3.Please choose 32-bit runtime in the step of job.

Best Regards,
Mona

---

If the response is helpful, please click "Accept Answer" and upvote it.

Answer 2

Hi Mona,
Thanks for your answer.
Yes, all these is already checked.

Answer 3

Hi Mona,

Thanks a lot for your suggestions.
I went back again to doble-check the permissions of the User-Account.
It was not exactly for the excel files, but within the SSIS.
We check and include the User-Account in the Admin group and now IS WORKING !!!

Thanks a lot and wish you a fantastic day.

Alex