Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

DTS package to pass data between two databases Expand / Collapse
Author
Message
Posted Tuesday, January 29, 2008 3:18 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, June 10, 2013 5:42 AM
Points: 42, Visits: 37
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.
Post #448748
Posted Tuesday, January 29, 2008 9:59 AM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Friday, April 5, 2013 4:43 PM
Points: 1,473, Visits: 1,314
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?
Post #448975
Posted Thursday, January 31, 2008 8:58 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, June 10, 2013 5:42 AM
Points: 42, Visits: 37
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.
Post #450008
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse