|
Home > Archive > MS SQL Server DTS > November 2005 > Re: How to resolve using Dynamic task in reading multilple svr con
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Re: How to resolve using Dynamic task in reading multilple svr con
|
|
|
| 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@microso
ft.com:
>
>
>
| |
| Allan Mitchell 2005-11-25, 3:23 am |
| 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@discussions.microsoft.com> wrote in message
news:26E75F62-CE40-4565-9E44- 5FC10ADD2631@microso
ft.com:
[color=darkred]
> 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:
>
>
> are
>
> servers
> run-time
>
|
|
|
|
|