Hi
We had a set of SSIS package on SQL 2016 writing the output to Excel with different tabs. In the old server we have ACE 2010 version 14 32bit.
We had to upgrade our servers to
Windows 2022
SQL 2022
we installed ACE 16 32bit but when running the SSIS package using SQL Agent (with 32 bit ticked), shows Unexpected termination and does not write to Excel correctly.
We even tried to install ACE 16 64 bit but still does not write to excel.
Would you please tell me what are my options? How to fix it?
Thank you
Kati