DTS: Copy new + modified records from table1 to table2 from two different servers

[suren1503]

Hi All Techies,

I have created one DTS to copy table1 (which is on Oracle server) to table2 (on SQL Server 2000)
I want to copy only new records + modified records from table1 to table2.

I would appreciate the help.

Thanks,
Suren...

[Delerna]

Similar to another thread

see if this helps

[rsrinivasan]

Use tableDiff utility of SQL SERVER 2005 that will sync only updated and inserted table.