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:
- Right-click your solution
- Click 'Properties'
- Select 'Debugging' node
- Set 'Run64BitRuntime' property to False
- Save and re-run your solution
- Click Apply
- 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:
- Go to SQL Serve Agent option
- Right click on Jobs and select
- Go to steps and click on New
- Fill out the options with your package information
- Click on configuration
- Click on Advance
- Check on 32 bit
- Click on OK
- Complete your job and run it
