I am trying to follow an article I found on this site...
http://www.databasejournal.com/featu...le.php/3325731

to import multiple text files using DTS.

I have started to create the DTS, but when I add the Text File (Source) connection, it makes me specify the text file that it is going to use, but I want the FileName to be a global variable.