Forum Discussion
SSIS issue when loading excel file into SQL server
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-ver16
https://learn.microsoft.com/en-us/sql/integration-services/extending-packages-scripting/task/connecting-to-data-sources-in-the-script-task?view=sql-server-ver16
