I have two tables that I need to compare. The purpose of the comparison is
to check for duplicate records, or better said, check for new records in the
newer table. I then want to add the new records to the old table. The
newer table is expendable but the older table is the actual production
table.

I hope this post makes sense, if anyone needs more clarification, please let
me know.

TIA
RC-

RC- wrote:
You can write a simple SQL task:
select * from Table1 where id_field NOT IN (select id_field from table2
where datefield > somedate)
You can insert the result set into some temp table and in the next task
punp it into you target table.
I included where clause with date in it, cause it could be useful in
many queries.
Good luck.

Vadim