Friday, February 21, 2014


Error: SSIS Error Code DTS_E_OLEDB_NOPROVIDER_64BIT_ERROR. The requested OLE DB provider OraOLEDB.Oracle.1 is not registered -- perhaps no 64-bit provider is available.

Details: Error occurs when attempting to run a SQL Agent job that runs SSIS package that opies data from Oracle to SQL Server

Cause:64 bit OLE DB provider Microsoft.Jet.OLEDB.4.0 is not installed on a 64-bit machine.
Solution:Run the SQL Agent job in 32 bit mode:
  1. Right-click on the job name and select Properties
  2. Go to Steps
  3. Select the step your job fails on and click Edit
  4. Select "execution optons" tab and check a "use 32 bit runtime" checkbox

No comments:

Post a Comment