This is what I do:

put a for each loop with a file enumerator on the source folder and specify a wildcard in the filename.

Specify that the full path should be retrieved and I put this in a variable.

On the Excel connection manager, I specify an expression using this variable.

Set DelayValidation = TRUE on the dataflow.

Normally that's all you need to do.