Hi Guys., we are using Excel source getting error : 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. Please help me out to reslove the error ThanksRanganathan.Palanisamy

Is your machine a 64-bit one?If yes,check this thread: http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/289e29ad-26dc-4f90-bad4-ffb86c76e5f9 Please mark as answer if this helps. Thank you. http://thebipalace.wordpress.com

Is that happening after you deployed this package to another box? How do you run your package? Did you enable a configuration or set the connection in DTExec?Arthur My Blog