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
![](https://i0.wp.com/swatilathia.com/wp-content/uploads/2022/01/step1.png?resize=575%2C405&ssl=1)
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”
![](https://i0.wp.com/swatilathia.com/wp-content/uploads/2022/01/image-11.png?resize=689%2C422&ssl=1)
Now Press Apply n OK. That’s it. Have Fun!!.