SQL Server 2012 SSIS - ACE.OLEDB.12.0 64-bit Issue
If you get the following error -
Microsoft.ACE.OLEDB.12.0 provider is not registered...
You can install 64 bit version of Office 2010 and it will fix the issue. If you have 32 bit version installed, uninstall it first and then install 64 bit version. It worked for me.
Showing posts with label 3. SQL Server. Show all posts
Showing posts with label 3. SQL Server. Show all posts
Friday, January 4, 2013
SQL Server 2012 SSIS Excel import fail issue due to OLE Jet driver
SSIS project fails to build due to OLE Jet drive 64 bit version and you get the following error:
Microsoft.Jet.OLEDB.4.0 is not registered
Here is what you can do:
Right click on your SSIS project name and choose properties, go to Configuration Properties -> Debugging tab. (expand Configuration Properties if you do to see Debugging right way).
Make the value of the property Run64BitRuntime to be false.
SSIS project fails to build due to OLE Jet drive 64 bit version and you get the following error:
Microsoft.Jet.OLEDB.4.0 is not registered
Here is what you can do:
Right click on your SSIS project name and choose properties, go to Configuration Properties -> Debugging tab. (expand Configuration Properties if you do to see Debugging right way).
Make the value of the property Run64BitRuntime to be false.
Subscribe to:
Posts (Atom)