SSIS issue when loading excel file into SQL server

Copper Contributor

Hello Friends,

 

I have an issue when I am loading excel workbook into SQL server using SSIS.  Here is the error message I get.  Can anyone help me to resolve this issue?

Error: 0xC0209303 at Package, Connection manager "Excel Connection Manager": 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.

 

Your help is highly appreciated.

 

Thanks

1 Reply

Based on the given details, the error seems due to, the Microsoft.Jet.OLEDB.4.0 is not installed. So, you could try installing the Microsoft Access Database Engine 2010 Redistributable:
https://www.microsoft.com/en-us/download/details.aspx?id=13255
Just make sure of the proper version (32/64-bit). For more details you could also follow these links:
https://learn.microsoft.com/en-us/sql/integration-services/packages/dtexec-utility?view=sql-server-v...
https://learn.microsoft.com/en-us/sql/integration-services/extending-packages-scripting/task/connect...