Posted by Yas on 08/16/07 12:15

Hello,

I have 2 tables, Table1 and Table2. I have copied all data from Table1
to Table2.
However Table1 is dynamic it has new rows added and some old rows
modified everyday or every other day...
How can I continue to keep Table2 up to date without always having to
copy everything from Table1?

Basically from now on I would only like to copy new rows or modified
rows in Table1 to Table2 and skip rows that are already present and
have not been modified in Table1. I would like to not do anything for
any rows that were removed in Table1 and continue to keep a copy of
them in Table2.


Is using a DTS package the best way to automate this update of Table2
to make sure Table2 is always up-to-date with Table1?


Thanks for any help or advise :-)

Yas

[Back to original message]