I am trying to do a import of text csv file into SQL using the import/export wizard and it works pretty well for me.

however, i need to do a schedule jobs to import these text files which are eg. day1_001.txt, day1_002.txt, day2_001.txt ....

Everday the files are created at the target PC. I will do a ftp to my SQL server and import it to the DB. How can i automate the process. How do I use DTS to schedule import of different files names?

Pls kindly advice.