Description: SSIS Error Code DTS_E_OLEDB_NOPROVIDER_64BIT_ERROR. The requested OLE DB provider SQLNCLI.1 is not registered — perhaps no 64-bit provider is available. Error code: 0x00000000. An OLE DB record is available. Source: “Microsoft OLE DB Service Components” Hresult: 0x80040154 Description: “Class not registered”. End Error

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

  1. Right click the job go to properties
  2. Select Steps from the left pane
  3. Double click the job step and select Execution Options Tab
  4. Select Use 32 bit runtime and  save

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *