The standard Data Flow Task supports only static metadata (columns), defined at design time. If you can use third-party solutions, I would recommend you check the commercial COZYROC Data Flow Task Plus. It is an extension of the standard Data Flow Task, which supports dynamic metadata at runtime. You can handle input files with arbitrary number of columns. No programming skills are required.

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