Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
brandonl
Yak Posting Veteran
58 Posts |
 Posted - 2003-02-18 : 13:45:07
|
| Currently, I have about 140 SMS servers (for those of you who aren't familiar-it runs on SQL). The server list is dynamic, in that servers are added/removed here and there.My problem is: I am currently importing about 40 tables from all the servers into one centralized database for reporting purposes. The SMS databases that I pull from have their own id's assigned to clients in the tables, and those can overlap from server to server-so I do a join when pulling the tables to change the MachineID field to the actual machine name. That is then inserted as the record on the central server.In the current system I am using VBScripts running daily that pulls the current list of servers (done daily), connects to each one-turns the customized queries for the tables into a recordset-then inserts that (via INSERT statements) into the central server.What I'd like to know is if there is a better way to do this? I've thought of making inidivdual DTS packages for each of the tables, but would it work with the dynamic serverlist? Can I pass the servername to connect to into the DTS package?I don't think replication will work-since my tables are not carbon copies of the table on the SMS server-they are slightly modified.Or is there a better way?~BrandonL |
|
|
|
|
|
Import of remote tables scenario question (SMS rel