Unexpected Termination - SSIS package writing to an Excel file

Question

Hi

I have an SSIS Package that writes to an excel file. It works fine in the DEV environment but wouldn't work in LIVE, the error was Unexpected Termination with no errors in the messages. I uninstalled and reinstalled the access database engine (version 16.0.5044.1000) which fixed the issue. This morning it started failing again with the same error. I uninstalled and reinstalled and ran the package (fairly quickly after the install) and this failed. I left it a while and tried again and it worked (perhaps it wasn't finished doing whatever it does!).

I am not sure if the uninstall and reinstall actually is the fix or if it was a coincidence.

If it starts failing again where can I look for what the issue is?

Both DEV and LIVE are on Windows Server 2012 R2 Standard and SQL Server 2016 13.0.5865.1.

Example error below

Thanks

Sam

Answer 1

Hi @Anonymous ,

Please download and install both 32-bit and 64-bit Microsoft Access Database Engine.

The following links will be helpful:
1.Microsoft Access Database Engine 2016 Redistributable
2.Installing the Microsoft.ACE.OLEDB.12.0 Provider for Both 64-bit and 32-bit Processing

Best Regards,
Mona

----------

If the answer is helpful, please click "Accept Answer" and upvote it.
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.