Hi there,
Just a query , how do we use Dynamic Task properties to read from an .ini
file all the server datasource, uid,initial catalog and password from
multiple servers as sources to a single destination servers.

I am not sure that the DP task is best suited here. You would either
need to supply many keys or supply 1 key and a comma seperated list. A
better idea IMHO would be to have the details you require held in a
database table. You can then iterate over that table easily

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

Allan


"Aishu" <Aishu (AT) discussions (DOT) microsoft.com> wrote

Hi there,
My question here is what is the best practice -- I have about 5 servers with
different infomation such as Datasource,UID,initial catalog,password this
infomation i am using Dynamic task to fetch this information at run-time to
transport to a destination server,Is this a best practice pls advise

Rgds,
Aishu


"Allan Mitchell" wrote: