import data into SQL server - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

import data into SQL server

import data into SQL server# Database - 数据库

i*e2003-07-09 07:07

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*s2003-07-09 07:07

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*e2003-07-09 07:07

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*a2003-07-09 07:07

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.