Recently, we were working on SSIS to get data from AX to the staging tables. As part of the requirement, we were also using Excel Connection Manager to read the data from one of the excel file and load it to a table.
After completing the development, we executed the package and it was successfully executed. Then, we deployed the package to SQL Server.
After deployment, when we executed the package it started giving us the below error:
“The requested OLE DB provider Microsoft.Jet.OLEDB.4.0 is not registered. If the 64-bit driver is not installed, run the package in 32-bit mode. Description: Class not registered.”
To fix the issue, we executed the package from SQL Server in 32-bit mode by following the below steps:
- Select the package –> Right Click on it –> Select Execute
2. Go to Advanced Tab –> Select 32-bit runtime –> Click OK.
The package got executed successfully.
Hope it helps !!