-
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.
-
Will not by default, you can try to add -m option for max number of errors.
-
Originally Posted by rmiao
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
-
Forum Rules
|
|