I have a SSIS 2019 project, which contains a main package and a few child packages that may export data to excel files (using Excel 2007-2010). The main package calls the child packages based on criteria. The excel files are dynamically generated though they use fixed file templates. If I ran the packages from my local computer, they work totally fine. However, if the packages were executed from the server, it could fail with "Unexpected Termination" error when the data was exported to multiple excel files. The bizarre thing is that it didn't fail all the time. Sometimes it might succeed. I checked all the logs (windows, SQL Server, SSIS, ...) but found no error messages anywhere. If the data is exported to only one excel file, it won't fail.
The server has "Microsoft Access Database Engine 2016 Redistributable - 64bit" installed. I have tried the 32bit version, which didn't work. Does anybody have any related solution? Or is this a bug in the "Access Database Engine 2016 Redistributable"? Thanks.