SSIS foreach loop xlsx files
I've run into this before and have used 2 different approaches.
If the process should only run if files exist, I've written a c# script to set a flag 'DataExists' so I can evaluate and take different paths within the SSIS package.  The other is I have a dummy file on the directory and when I build the expression in the foreach container I use variables that will use that dummy file name/location if nothing else exists.   Hope that helps.