I have a Windows Server 2022 machine hosting SQL Server 2022. I am deploying to the server an SSIS package that produces output to an Excel file. In order to do this, I need Microsoft Access Database Engine 2016 Redistributable installed on the machine.
During development locally in a Windows 10 machine, the SSIS package worked well. However, I encountered issue running the SSIS package on the server as Microsoft Access Database Engine 2016 Redistributable did not install. Running the installer just popped up the command line prompt for one second and finished without error. Installation log also indicated no failure. Reading the OS requirement of the installer, Windows Server 2022 is not supported.
The only newer Microsoft Access Engine than 2016 that I can find is Microsoft 365 Access Runtime. I am still looking for the Microsoft 365 Access Runtime offline installer as the Server box does not have internet access.
My questions are
- Is there an alternative runtime to Microsoft Access Database Engine 2016 Redistributable that can allow SSIS 2022 to export data to Excel?
- Will Microsoft 365 Access Runtime integrating well with SSIS. (I still need to do a PoC for this but I appreciate any advice)
- If not, is there any way to force install Microsoft Access Database Engine 2016 Redistributable on Windows Server 2022?
I am also considering writing a command line application in .NET or PowerShell to write to Excel file, and have the SSIS package to call the command line but this will be my last resort.
I appreciate any advice. Thank you.