Problem:
Environment: Window 7 - 64-bit, VS 9.0 64-bit
Destination: Excel 1997-2003 file
Error when running the package:
"SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "
Solution:
Make Run64Runtime to False
