I am trying to append some 50000 rows of data from table A to table B in the
same database using DTS. Howvere I get an error message which says "Error at
destination for row number xxxxx.Errors encountered so far in this task:1.
The statement has been terminated. Violation of PRIMARY KEY constraint
'TI_PRIMARY'. Cannot insert duplicate key in table 'B' ". The row number
xxxxx is always the last row.

For example, in the first error message the row number was 50000 and I had
50000 rows of data. I deleted 500 rows. Now I get the same error message with
row number as 49500. I have checked the source table and there is no primary
key violation.

Please let me know what to do. Thanks.