dbTalk Databases Forums  

DTS: Copy new+modified records from table1 to table2

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss DTS: Copy new+modified records from table1 to table2 in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Sur
 
Posts: n/a

Default DTS: Copy new+modified records from table1 to table2 - 08-21-2008 , 10:12 AM






Hi All Techies,



I have created one DTS to copy records from table1 (which is on Oracle
server) to table2 (on SQL Server 2000).
In the first execution I want to pull all the data, but from next time
onwards I want to copy only new records + modified records from table1 to
table2.

Please let me know how can I do this?
I would appreciate the help.



Thanks,
Sur...

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.