The requested OLE DB provider is not registered — perhaps no 64-bit provider is available. And what OLEDB provider you are using? Does it exist for 64-bit, is it installed?
The error means that the OLDEDB provider you are using to connect to SQL server is only support on 32 bit run-times
To resolve the issue configure the package to run using 32-bit runtime
- Right click the job go to properties
- Select Steps from the left pane
- Double click the job step and select Execution Options Tab
- Select Use 32 bit runtime and save