Monday, January 25, 2016

Solution for SSIS Error code 0xC0209303

When we try to load data from MS-Access to SQL server using SSIS we can get an error with code "0xC0209303"

SSIS Error Code DTS_E_OLEDB_NOPROVIDER_64BIT_ERROR.  The requested OLE DB provider Microsoft.Jet.OLEDB.4.0 is not registered


Solution :we need to run the package in 32bit  mode

Under SSIS package project properties--> Click debugging and set Run64BitRuntime to False

No comments:

Post a Comment