Hi all,

Can some one give me solution for my problem...

Problem:

I have few SQL servers.. I need to design a DTS package that connects to all these servers and fetch the data ( eg query : select count(*) from master.sys.databases).

My approach :

I create a table with all the server names stored in it. Now, My DTS package shud connect to each server in the table and execute the query.. But for my the hurdle is ..how to change the ConnectionString dynamically..( i mean how to connect to all the servers one-by-one fashion)..

Any help/suggestion is appreciated.. can also suggest another approach also..

[font="Comic Sans MS"] Thanks in advance[/font]

[font="Comic Sans MS"]Vampire[/font]