Yes Elliott, both of them are running on the same server. As the local server is a production machine, I'm not querying the data for each comparison. I fetch the...

Thanks for your reply Elliott.

The package is basically performing the task of data comparison / data synchronization. For each run, it does so for approximately 1200 servers. It basically compares...

Thanks Guys,

I tried the script approach and it worked :-), but :ermm: it seemed more like a workaround rather than the real solution.

The DMO was too long a shot so...

Raunak Jhawar (8/16/2010)

---

Siddharth,

Foreach with one scipt task and EST. Loop parameters ki value...name of server will change upon some condition....now we have a server name...script task and EST...easy...but remember to...

Not really because that's a long shot but thanks for...

Baskar B.V (8/16/2010)

---

I hope this dynamic mapping would not help inside data flow task. Because even if you map server name to the connection at run-time you can't do the...

Thanks Lynn