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 |
|
bpsintl
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. |
|
|
SwePeso
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" |
 |
|
|
|
|
|
Exporting to another server