I'm sure there is obvious way of doing this, but I haven't used DTS in
a long, long time.

What I'm trying to do is to import log files from some web servers that
are clustered. I've had no problem with importing the text file, but I
don't know how to handle a variable number of web servers. The number
of web servers is variable, and I don't want to have to change my DTS
package everytime the number of servers changes. So what I want to do
is create a db table to store the server addresses and then to have
some part of the dts package loop through that table and run the "meat"
of the package for each record in that server table. Is there a way to
do this?

In message <1107294373.719783.122420 (AT) f14g2000cwb (DOT) googlegroups.com>,
ticars (AT) yahoo (DOT) com writes
I would have two packages, the main (child/inner) package imports the
data and does the real work. The parent or outer package would run the
query to say how many times and for what servers do I need to run the
main package.

Use an Exec Pkg Task to call the child package. To drive a loop off a
query try this-

How to loop through a global variable Rowset
(http://www.sqldts.com/default.aspx?298)

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org