Are the source Excel files with same structure (number of columns, meaning, etc)? If that is the case, it will be easy. You have to setup data flow task with the following components in it:

* Excel Source component

* Flat Destination Component.

Then you have to setup your Excel connection manager to be set through expression, so you can iterate it over with foreach loop.

If your source Excel files doesn't have same structure, then I would recommend that you avoid using SSIS. It will be not too much of a help and you would have to implement a custom program, which processes the files.

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/