Regarding SSIS (SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel" failed with error code 0xC0202009.)

[Ravikiran72p]

I am new to ssis. I Created on pakcage which loops excel fils(.xls) of one folder and extracts to database. I placed Excel files in one folder (like C:\Documents and Settings\username\My Documents\Temp). The Sqlserver2005 server located on another machine (where i need to dump the data from excel to this destination server.) I am running package on my local machine. When i run it is giving below error at Excel Source of Data Flow task. SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel" failed with error code 0xC0202009. Please help me out. Thanks, Ravikiran

[Mycroft Holmes]

My usual attempt to resolve a sql error is to drop the error message into google[^] - seems like it is a common problem.

Never underestimate the power of human stupidity RAH