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