Data warehousing : Assignment – 1 & Old Papers
Some old papers of Data warehousing (Old & New course) & Assignment 1 (ETL with SSIS) are attached. Just check it out once
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!!.