Swati Lathia

Learning ways

Data Warehouse

Data Warehousing with SQL server 2012

Excel Source/Destination Error Solution in ETL (Data Warehouse)

Sometimes, we face an issue related to excel source or destination. We get an error like “Excel Source/destination failed validation and returned error code 0xC020801C” or “SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager “Excel Connection Manager” failed with error code 0xC0209303″. The reason for this run-time error is that Excel does not have a 64-bit driver which is selected by default in SSIS running on 64bit OS. 

To solve this issue, follow these steps :

Step 1 – Select Project Menu -> [Project Name] Properties

Step 2 – In left sidebar, there is a Configuration Properties . Select Debugging. In Right sidebar, There is an option Run64BitRuntime. Set this property from “True” to “False”

Now Press Apply n OK. That’s it. Have Fun!!.

Scroll to top