I need to move data from a temporary table into a production table. The temporary
table has records that a) are new and do not exist in the production table
and b) has updated information for records that exist in the production table.
In other words I need to update the existing records as well as append with
new records. I am trying to do this through DTS. I very much need help
with this!!! Any help would be really appreciated!