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