"Excel Connection Manager": The requested OLE DB provider Microsoft.Jet.OLEDB.4.0 is not registered

Sometimes while importing data from Excel source following error is generated.This can be solved by using simple steps listed below.

Error Message-

 0xC0209303 at Package, Connection manager "Excel Connection Manager": 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.

Solution –

IN Business Intelligence Development Studio

Go to Project --> Project Properties --> configuration Properties --> Debugging -->

Run64bit runtime-

Set it to False.