Hi @BlueFire291,
- SQL Server 15.0.2101.7
Your SQL Server never received even CU1. It is recommended to install the latest CU19, build 15.0.4298.1 - Visual Studio 2019 with SSDT 4.2,
SSDT is no more for the SSIS development in VS2019. You are using SQL Server Integration Services Projects extension for VS2019. Its 4.2 version is not a GA. All its 4. versions are for connectivity with SQL Server 2022. It is better to use v.3.16, which is GA and supports Microsoft Connector for Oracle.* - Microsoft Access Database Engine Redistributable 2016 x86 (release date: 8/11/2020) (the runtime is set to x86 as is the step of the job).
There is no need for Microsoft ACE OLEDB Provider 32-bit edition on a server. It is a requirement to use it on the developer machine due to dependencies on the VS2019 which is a 32-bit application. It is better to use Microsoft ACE OLEDB Provider 64-bit edition on the SSIS run-time server.
Now back to your main issue.
Please connect in SSMS to the SSIS run-time server SQL Server instance as "the same user account" in question.
Please issue the following command in SSMS connected to the SSIS run-time server, and share the outcome:
EXEC master.sys.sp_MSset_oledb_prop;
You should see something like below:
Also, issue the following command in SSMS connected to the SSIS run-time server:
SELECT *
FROM OPENROWSET('Microsoft.ACE.OLEDB.16.0',
'Excel 12.0 Xml; HDR=NO;
Database=fullyQualifiedPathToExcelFile.xlsx',
[Sheet1$]);