At the following link you will find Video Tutorials of:
A tutorial on creating a SSIS package that will dump the contents in a flat file into a single database table. It means that the SSIS package will insert multiply text file into database. The video demonstrates it on old version of SSIS but the concept of passing variable as flat file name is the same and it is the main point here.
Here is the video: