i******e
发帖数: 32 | 1 When I import data in to the SQL server, it gives an error because the
duplicate record and stops. However, is there a way to let the work keep
going for the rest of records? |
e*********s
发帖数: 200 | 2
Are you using DTS to import to a new table or existing table?
【在 i******e 的大作中提到】
: When I import data in to the SQL server, it gives an error because the
: duplicate record and stops. However, is there a way to let the work keep
: going for the rest of records?
|
i******e
发帖数: 32 | 3 Existing table. My purpose is to let the primary key of the destination table
to get rid ofduplicate records in the source table.
【在 e*********s 的大作中提到】
:
: Are you using DTS to import to a new table or existing table?
|
a*****a
发帖数: 438 | 4 how about drop the primary key contraint first and then run a query
after DTS to delete dup copies, then turn on primary key contraint again
【在 i******e 的大作中提到】
: Existing table. My purpose is to let the primary key of the destination table
: to get rid ofduplicate records in the source table.
|
l*********r
发帖数: 80 | 5 how to delete dup copies?
【在 a*****a 的大作中提到】
: how about drop the primary key contraint first and then run a query
: after DTS to delete dup copies, then turn on primary key contraint again
|
a*****a
发帖数: 438 | 6 hmm.. at least you can select distinct into another table bah;
【在 l*********r 的大作中提到】
: how to delete dup copies?
|
