I hope you'll be able to help me with this question.

I'm suppose to import the content of formatted text files every hour. I'm able to do so using the DTS package. But here's the problem, the text files, although have the same formatted fields, have different names, dependent on when they are created. As a result, I have to schedule 24 DTS packages in order to get all the contents loaded into the database.

Is there an easier way to do this? Say, is there an SQL procedure that I can call and pass the source and the destination parameters and SQL would do the same import task that it does when I schedule a DTS package.

Any help would be much appreciated.