SSIS Error Code Dts_e_oledb_noprovider_64bit_error

Move a batch of jobs from one agent server to another agent, without any modification, but the job execution error.

1 error:2014-07-03 14:42:57.14 2    code:0xc02093033   source:reliabilityrs2008 Connection Manager "Dwprod"4     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. 5 An OLE DB record is available.  Source: "Microsoft OLE DB Service Components"  hresult:0x80040154  Description: "Class not registered".

OLE DB provider SQLNCLI.1 is not registered--perhaps a OLE DB record is available. Link error, but in vistual inside test obviously no problem.

So Baidu tried a lot of ways, such as re-set the entire project properties, change the Run64BitRuntime to false, but no use.

Finally found is a configuration file problem, the configuration file inside the specified OLE DB provider is SQLNCLI.1 to a higher version of the SQLNCLI10.1, problem resolution.

You can also delete the 2 configuration files here, the link will be used every time you update the package inside the link, in the job properties of the DataSource paging,

When there is configurations file, the limited use of configurateion inside the file, otherwise with DataSource inside.