Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Exporting to another server

Author  Topic 

Posting Yak Master

132 Posts

Posted - 2009-05-14 : 06:55:02
I have 2 servers on the same network. What would be the best way to get data out of one, into the other, replacing all the data with the new data. I will be copying certain fields from the 1st db and importing those into the 2nd db.

I would like to set this up as an automated daily job.

Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-06-04 : 05:14:38
Use the Lookup task in your package.

E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page

- Advertisement -