I am just learning SQL so be gentle... But i have a
single database that I want to back-up on another SQL
server for archiving data. Now in the DTS Wizard I only
see the options for Replace Data and Append Data but using
the Append Data option gives me 'Duplicate Primary Key
Errors' but I want it to not copy those, just the new
records. Is there any way i can build an Update package
that will only copy over to the other the new records not
replace the entire table? I do not want my live database
to contain but the last 2 months of data then at the first
of every month I move the data to the Archive database
THANKS IN ADVANCE!!!!