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.