July 31, 2014 at 1:03 pm
Hello,
I am in the process of migrating SQL 2005 - 2012 and I am reconfiguring my SSIS packages. I have a master package that runs over 200 packages. I get the error below while testing. I have Googled this error and the response doesn't seem right. I am apparently supposed to run my packages in 32 bit mode because this driver is unavailable? Doesn't make sense. I ran the package in 32 bit and it worked, BUT apparently Microsoft Jet 4.0 DB Engine is no longer supported. Does anyone know which updated driver I can use for 64 bit?
Please help my friends 🙂
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.
An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered".
The are no problems, only solutions. --John Lennon
August 1, 2014 at 1:33 am
What are the packages connecting to when you get this message? Flat file, excel file...etc
August 1, 2014 at 1:37 am
There isn't a 64bit version of the Jet driver, you will need to run the package in 32bit mode.
August 1, 2014 at 1:45 am
You might be able to use a different driver like ACE but depends what you are connecting to.
http://www.microsoft.com/en-gb/download/details.aspx?id=13255
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply