DTS: Copy new+modified records from table1 to table2This is a discussion on DTS: Copy new+modified records from table1 to table2 within the sqlserver-dts forums in Microsoft SQL Server category; 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...... | ||||||||
| | ||||||||
| ||||||||
| Register | FAQ | Calendar | Search | Today's Posts | Mark Forums Read |
|
#1
08-21-2008, 12:12 PM
|
 DTS: Copy new+modified records from table1 to table2 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...  |
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
All times are GMT -4. The time now is 02:39 AM.
