January 29, 2008 at 3:18 am
I want to monitor file growth across a number of databases on different servers from a central point. I'm using a DTS package and what I want to do is avoid hard coding each server, database, datafile etc. I set up a DTS package which connects to the remote server and collects the data I need, but I can't work out how to get it back and then pass it into another SQL task which will update some tables in the central database. The gathering and inserting SQL are no problem but it's the method by which I get them from one task to another that's giving me a problem. Any suggestions? Thanks.
January 29, 2008 at 9:59 am
Did you try to collect data from your remote servers, insert into a temp table in your "central point", then migrate the data to wherever you want?
January 31, 2008 at 8:58 am
Yes, I think I'm going to do that - create some temporary tables on the source, copy them across with the copy objects and then run the analysis on the local server. It's not hugely elegant but it will do the job.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply