SSIS - [Excel Source [11]] 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.

 Well well,

I had promised my client that I would deliver an SSIS package in a day's time as I had estimated the task completion to be an hour. But alas..I got stuck with this error. 

It took me whole day to resolve this error.

Resolution

Recreate the folders

Bingo..!Issue fixed

Cause - 

SSIS seems to have had problems in connecting to files that existed in prior folders. So I deleted the folders, recreated and then placed my excel files in it to get it resolved