SSIS Error:The GetEnumerator method of the ForEach Enumerator has failed

Problem Statement: SSIS package failing with below error.

Error: The GetEnumerator method of the ForEach Enumerator has failed with error 0x80004005 "Unspecified error". This occurs when the ForEach Enumerator cannot enumerate.

Requirement : Using ForEachLoop ,import data from multiple excel and each excel will have one or more sheets with different sheet names. Hence need to automate this using FOREACHLOOP functionality.

Steps : 1) First/external FOREACHLOOP will loop multiple excels using variables. 2) Second/Internal FOREACHLOPP will loop or pick sheet name for different excels. 3) Second/Internal FOREACHLOPP will have “Foreach ADO.net schema rowset enumerator” and excel file path give as source file.

I understand error is because enumerator not able to find the file .But why so I am not able to find. Though connection manager has proper excel path and foreachloop for excel loop alone works fine.

Not sure how to solve this error. Need some help.