bcp resume
Results 1 to 3 of 3

Thread: bcp resume

  1. #1
    Join Date
    Dec 2010
    Posts
    4

    bcp resume

    does bcp from text file to table resume when it encounters primary key violation?

    sorry if this was discussed before and i am unable to get a straight answer. yes i can try but right now i dont have an immediate environment.

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Will not by default, you can try to add -m option for max number of errors.

  3. #3
    Join Date
    Dec 2010
    Posts
    4
    Quote Originally Posted by rmiao View Post
    Will not by default, you can try to add -m option for max number of errors.
    so the initial inserted records will remain and once the error occurs, such as the this primary key, it stops. is there a mechanism to skip the record and go on to the next?

    i'll have to test various options.

    thanks for your reply

Posting Permissions

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