|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
DTS - copying table data
hi all,
i have a dts that copies table contents from remore server to local server. remote table: ItemID|name 1 |name1 2 |name22 3 |name33 local table: ItemID|name 1 |name1 2 |name2 i want that the dts will only copy the new rows( aka. row with ItemID = 3) and leave the other rows a they are. can any one help me create such a dts. please help! ![]() |
|
#2
|
||||
|
||||
|
Use a Lookup in your DTS
__________________
My blog Tutorials about OSS databases, DBMonster ... Contribute to OSS Development, fill bug reports! Developer Shed eSupport Commented my.ini/my.cnf (ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins Random data (with a bias) |
![]() |
| Viewing: Dev Shed Forums > Databases > MS SQL Development > DTS - copying table data |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|