SSIS - Excel connection Manager
If you have a 32 bit Excel installation, and try to read Excel from SSIS, you will likely get this error: Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER All you need to do is to disable 64 bit Runtime: Project -> Properties -> Configuration Properties > Debugging -> Run64BitRuntime -> Set to False.