"Aishu" <Aishu@discussions.microsoft.com> wrote in message
news:26E75F62-CE40-4565-9E44-5FC10ADD2631@microsoft.com:

> 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 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@discussions.microsoft.com> wrote in message
> > news:99DBA800-E6F6-4C21-9B79-E87FE4D7DF02@microsoft.com:
> >
>
> > > 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
> >
>
> >