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

I personally would not use the DP task.

I would use as mentioned a GV rowset in a loop. You can secure the
source table against prying eyes because if for no other reason you are
storing passwords.

Allan

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

Hi Alan,
Thks alot..........its been great help.......how do u think Iam going to
fetch the server datasource ...advise me the best practise....is it ok to
store the servername from a source file or a table? if so can u give me an
example

Rgds,
Aishu

"Allan Mitchell" wrote:

I Do this

I have an alias configured in CliConfig to a server/database where I
store all package details.

I connect to this at runtime and retrieve these settings. I store
everything and anything in there. If my package needs it I store it.


Alln


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