CSS Pseudo
CSS pseudo is a special state of an element. It is used to style for links, divisions any many other elements.
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!!.