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
[quoted text, click to view] "Allan Mitchell" wrote:
> 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@discussions.microsoft.com> wrote in message
> news:AF47C041-F534-4537-993E-027720C0CBBD@microsoft.com:
>
> > 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
[quoted text, click to view] "Aishu" <Aishu@discussions.microsoft.com> wrote in message
news:AF47C041-F534-4537-993E-027720C0CBBD@microsoft.com:
> 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.
Don't see what you're looking for? Try a search.
