Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SSIS package fails with error "If 64-bit driver not installed, run in 32-bit mode"

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

like image 820
Scottdg Avatar asked Mar 29 '17 13:03

Scottdg


2 Answers

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.

like image 117
fahad Avatar answered Oct 02 '22 20:10

fahad


You have to install Microsoft Access Database Engine 2010 Redistributable and
set 64BitRuntime option to FALSE

you can get it from the following link:

  • https://www.microsoft.com/en-us/download/details.aspx?id=13255

More info and details can be found in the following links:

  • http://sqlblog.com/blogs/john_paul_cook/archive/2010/03/24/running-32-bit-ssis-in-a-64-bit-environment.aspx
  • http://toddmcdermid.blogspot.com/2009/10/quick-reference-ssis-in-32-and-64-bits.html?m=1
  • https://msdn.microsoft.com/en-us/library/ms162810.aspx
like image 32
Hadi Avatar answered Oct 02 '22 18:10

Hadi