I am trying to create a DTS package that imports data from a table,
transforms some information and dumps it into a flat file. My problem
is that we have about 300 properties with a separate SQL Server at each
property with the name of the server in the format XX0000X where X is a
letter and 0 is a number. Each of the servers has the same database
architecture. I need a way to loop through to connect to each server,
run the package and then proceed to the next server. I do not know how
to accomplish the task of looping through to each server. The way I
would like it to work would be to start at the first property, try to
connect, if the connection fails, send a mail message to report that
and then go on to the next server. I do have a table with listing of
all the servers. Any help would be greatly appreciated.
Sent via Deja.com http://www.deja.com/
Before you buy.