ForEach Enumerator has failed with error 0x80131509 "(null)"

SSIS ForEachLoop Error

I am trying to load multiple excel files with multiple sheets but after deploy into server only i am getting this error.

The GetEnumerator method of the ForEach Enumerator has failed with error 0x80131509 "(null)". This occurs when the ForEach Enumerator cannot enumerate.

i also changed in the properties Run64BitRuntime = false. anyone can suggest me what to do for this error?

FOReach loop container

This error gets thrown when trying to enumerate NULL. It looks like, once deployed, your SSIS package is not finding any excel files, and returning NULL, instead of an empty list.

Sources;

• Foreach loop container in SSIS using variable
• ssis error : foreach in foreach loop container

I'd suggest to put some logging in your package Before the enumeration to see if anything is found, then redeploy it, run and check your logs.