I am receiving the following error when trying to run the package from the Integration Services catalog in SSMS. I changed the 64BitRuntime
option to FALSE
but it still does not work. The error below is followed by an error that a connection cannot be made to my Excel connection manager
. Any suggestions?
Package 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. Error code: 0x00000000
if you are executing the SSIS package from job , there is an option in job configuration a checkbox "enable 32 bit".
OR
if you are executing the SSIS package from BIDS or SSDT , go to project properties=> Configuration => debugging => turn 64BitRuntime from "True" to "False" as it is set to True by default.
You have to install Microsoft Access Database Engine 2010 Redistributable and
set 64BitRuntime
option to FALSE
you can get it from the following link:
More info and details can be found in the following links:
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With