Go to SQLDTS.com and search for the word "Loop" to find some examples.

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




"Chris Hornberger" <chris (AT) chornbe (DOT) com> wrote

Each quarter or perhaps several more times per year, I have to run an
import on data from between 20 and 40 access DBs, each containing 700k
records (or so). I want to automate DTS in such a way that I can
simply feed it the file name of the MDB and call it in a loop. Each
Access MDB file contains one table that is always the same name, so
the only variable here is the file name.

I *could* simply rename the file to something like "currentimport.mdb"
and run a prepackaged DTS, then rename it when I'm done, and do that
in a loop, but if I can keep from messing with my original source
files, all the better.

Plus, this option goes away if I get them on CD which it looks like I
will be.

Thanks in advance.

Chris Hornberger
chornbe (AT) rcn (DOT) com