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 Pack...
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