Bullk copy doesn't always create rejections file immediately
When using a bulk copy the functions GET_NUM_REJECTED_ROWS() and GET_NUM_ACCEPTED_ROWS() are not supported. To decide on the number of rejected rows i want to scan the rejected files and count the number of lines there. Unfortunately from time to time, the rejections file is not immediately created (after the copy finishes) and my code decides that there are no rejections (when i know for sure there are). Is there a workaround for this issue?