Results 1 to 4 of 4
  1. #1
    Join Date
    May 2011
    Location
    Pune(India)
    Posts
    32

    Unanswered: How to avoid duplication while "bcp in" ?

    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

  2. #2
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    create a unique index with ignore_dup_key

  3. #3
    Join Date
    Jul 2011
    Posts
    2
    try

    -b1 -m9999999999

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

  4. #4
    Join Date
    May 2011
    Location
    Pune(India)
    Posts
    32
    Thanx wluk

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •