I have 800 visual fox pro tables that sit in a directory. I need to import
all the data in those fox pro tables to sql server tables. Should I use DTS??
If so, should I create 800 seperate transformation tasks for each table to
be imported (seems a little silly). Should I use a VB App that does selects
and inserts for each table??

How would you guys do it??

Thanks!