For the process you want to accomplish using the standard SSIS will not be much of help and will in fact make your solution even more complicated.

If you still want to use SSIS, I would strongly recommend you check the commercial COZYROC Data Flow Task Plus. It is an extension of the standard Data Flow Task , with ability to do dynamic data flows at runtime. If you decide to use it, you can accomplish the requirement with no programming skills required, exporting arbitrary table into a flat file.

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