BIDS is a 32-bit run time application (reference can be found here). So, when we are using SSIS we are using 32 bit facilities to build our package. Nowadays, we are using 64-bit OS and other hardware.
For Microsoft Jet Driver (MS Access or Excel), there is no 64-Bit version of Jet Driver so any packages using Jet driver (i.e. Excel or MS Access Database Connections) must be called using 32 bit DTExec. In this case, few tasks like Excel Source/Excel Destination will fail on running with following error messages.
- 0x80040154 … Class Not Registered
- The Acquire Connection method call to the connection manager XXX failed with error code 0xC0202009
- 0xC00F9304 … SSIS Error Code DTS_E_OLEDB_EXCEL_NOT_SUPPORTED
- The OLE DB provider “Microsoft.Jet.OLEDB.4.0” has not been registered
So, to run package in 32- bit run time. Go to Project -> Properties, change Run64BitRuntime to False, Apply and hit ‘Ok’.