How to avoid duplication while "bcp in" ?

gopalmpawar · #1 (**permalink**) 07-01-11, 05:52

Hi All,

I have a table which having some records. The file have some duplicate records and i want to "bcp in" by avoiding that duplicate records. Please help...

Thanx
Gopal

pdreyer · #2 (**permalink**) 07-02-11, 11:19

create a unique index with ignore_dup_key

wluk · #3 (**permalink**) 07-13-11, 11:34

try

-b1 -m9999999999

which will insert 1 row at a time and ignore any error 9999999999 times before abort.

gopalmpawar · #4 (**permalink**) 01-24-12, 07:46

Thanx wluk

Internet Services

Web Development

Digital Marketing

Consumer Tech