SSIS requirement at deployment server with Excel files as data source?

Hello,

I have a SSIS that was created from Visual Studio 2019.

It loads the data from an Excel file to a table in a SQL database.

The development computer has Windows 10, M365, and Microsoft Access Database Engine 2016 (both 32 and 64 bits).

It runs successfully in the development computer.

However, after I deployed it to the SQL Server, the Integration Service Catalogs, it does not work.

The SQL Server resides on a Windows server, which does not have Excel or any Office applications. It has Microsoft Access Database Engine 2016 (both 32 and 64 bits).

I tried Run64bitRunTime (True/False) in Visual Studio project settings, and a combination of one (either 32 or 64 bit) or both 32 and 64 bits of Microsoft Access Database Engine 2016 at the server. Tried different order of installation of Microsoft Access Database Engine too. But none worked*.

Someone mentioned in the SQL agent job, there is an option to run a job in 32-bit, but we do not have that option.

Anyone has an idea on how to resolve it?

Thanks,

Andy

PS:

*

The errors were among these 3 below for my testing of

a combination of

Run64bitRunTime (True/False) and

one or both Microsoft Access Database Engine 2016 (32-bit and 64-bit):

1.

unexpected termination

2.

Package:Error: The requested OLE DB provider Microsoft.ACE.OLEDB.16.0 is not registered. If the 64-bit driver is not installed, run the package in 32-bit mode. Error code: 0x00000000. An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered".

3.

External component has thrown an exception.; at Microsoft.SqlServer.Dts.Runtime.DtsContainer.Execute (Connections connections, Variables variables, IDTSEvents100 events, IDTSLogging100 log, Object transaction) at Microsoft.SqlServer.IntegrationServices.Server.ISServerEx ec.ISServerExecutionEvents.StartPackage() at Microsoft.SqlServer.IntegrationServices.Server.ISServerEx ec.ProjectOperator.StartPackage() at Microsoft.SqlServer.IntegrationServices.Server.ISServerEx ec.ProjectOperator.PerformOperation()

External component has thrown an exception.; at Microsoft.SqlServer.Dts.Runtime.DtsContainer.Execute (Connections connections, Variables variables, IDTSEvents100 events, IDTSLogging100 log, Object transaction) at Microsoft.SqlServer.IntegrationServices.Server.ISServerEx ec.ISServerExecutionEvents.StartPackage()