Hi,
REQUIREMENT :
1. Regularly update DATA FROM Database (DB1) to Database (DB2)
say FROM TABLE1 to TABLE2
2. IF row in TABLE1 is new INSERT in TABLE2
3. IF row in TABLE2 says the row has to be overwritten (SQL UPDATED) THEN
UPDATE the row.
(TABLE2 has a flag which says whether the row has to be UPDATED)
I would appreciate if anyone could help me with Requirement 3 using DTS. ( OTHER THAN DELETE / INSERT)
Thanks in advance,
RK
REQUIREMENT :
1. Regularly update DATA FROM Database (DB1) to Database (DB2)
say FROM TABLE1 to TABLE2
2. IF row in TABLE1 is new INSERT in TABLE2
3. IF row in TABLE2 says the row has to be overwritten (SQL UPDATED) THEN
UPDATE the row.
(TABLE2 has a flag which says whether the row has to be UPDATED)
I would appreciate if anyone could help me with Requirement 3 using DTS. ( OTHER THAN DELETE / INSERT)
Thanks in advance,
RK