DTS to UPDATE a table 
Author Message
 DTS to UPDATE a table

Apologies in advance if I am posting this in the wrong section.

I would like to use DTS to update a SQL Server table with employee info.
Unfortunately, the source of the employee info is in Oracle.

I know I could easily use DTS to INSERT all the HR data into a table,
but in this case the destination table already contains some valid data,
and I just want to update from the Oracle table based on employee id.

Should I load the Oracle data into a temporary table & then use SQL to
do the update, or is there a cleaner way?

Thanks for your help

Fri, 04 Apr 2003 03:00:00 GMT
 [ 1 post ] 

 Relevant Pages 

1. Using DTS to update multiple tables from a single input row

2. DTS Update table from Paradox tables

3. Update table through DTS

4. Request SAMPLE PROGRAM of Insert/Update table using DTS

5. Update tables with DTS

6. using DTS to update new records in table

7. Update table with DTS

8. Updating table data via DTS

9. update tables with dts

10. DTS source table Update Question

11. Updating sql tables using DTS

12. Update dimension table using DTS fail

Powered by phpBB® Forum Software