SSIS 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.

If you get the error:

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.

If the problem is in your development studio, you can fix it by running the package in 32 bit mode on your project:

1. Right-click your solution
2. Click 'Properties'
3. Select 'Debugging' node
4. Set 'Run64BitRuntime' property to False
5. Save and re-run your solution
6. Click Apply
7. Re-run your package

If the problem is in your SQL server put your package in a job and change the run time to 32bit:

1. Go to SQL Serve Agent option
2. Right click on Jobs and select 
3. Go to steps and click on New
4. Fill out the options with your package information
5. Click on configuration
6. Click on Advance
7. Check on 32 bit
8. Click on OK
9. Complete your job and run it