Hi I have been given 400 files to import into sql server
2000 they are all the same layout I have imported one
using DTS GUI no problem how can I mass import the other
399 if possible thankyou for any help

http://www.sqldts.com/default.aspx?6,103,246,0,0

--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm




"shau" <stull (AT) vodaphone (DOT) net> wrote


Hi I have been given 400 files to import into sql server
2000 they are all the same layout I have imported one
using DTS GUI no problem how can I mass import the other
399 if possible thankyou for any help

Save your DTS Package as VB, and modify the saved version
to loop through all the filenames executing the rest of
the package.

--
Ryan Hoegg
ISIS Networks
http://www.isisnetworks.net