I have to import some flat files in SSIS and I want the tables to have the saem name as the file being imported.

The files will be in a folder and I know I can use a loop process to pick those files up and get their filename but I'm not sure of the way to createfiles with thiose names as my data destination.

Any ideas.
Thanks

Nick