Unexpected Termination - SSIS package writing to an Excel file

Sam Garth 26 Reputation points Microsoft Employee
2021-02-08T16:56:12.163+00:00

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

68642-dumperror.jpg

Thanks

Sam

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,468 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Monalv-MSFT 5,896 Reputation points
    2021-02-09T02:25:14.207+00:00

    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.