What do you have to change to be able to execute a package where the error message says:
Error: 0xC020801C at Data Flow Task, Excel Source [1]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
?
Most of time, Excel is installed as a 32bits software but you try to execute a package in a 64bits BIDS installation.
To avoid this stupid error message, you have set the Run64BitRuntime property to false as shown in the below picture:
