DTS package to pass data between two databases

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » General » DTS package to pass data between two...

DTS package to pass data between two databases

Rate Topic

Display Mode

Topic Options

Author

Message

Kathy-268569

Posted Tuesday, January 29, 2008 3:18 AM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, October 24, 2012 4:58 AM
Points: 42, Visits: 36

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

SQL ORACLE

Posted Tuesday, January 29, 2008 9:59 AM

UDP Broadcaster

Group: General Forum Members
Last Login: Friday, April 05, 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

Kathy-268569

Posted Thursday, January 31, 2008 8:58 AM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, October 24, 2012 4:58 AM
Points: 42, Visits: 36

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 »

Permissions