DSXchange

Hi,

I am wondering if we can capture the number of rejected records using the job log. Usually, if few records rejects the job will finish with warnings and it will show only the number of records loaded but not the number of records rejected.
Can you please let me know how this can be captured?

There are a number of ways that records are "rejected" and the answer depends upon exactly what you mean in this case. Usually the best way is to the use stage reject link (when supported) to write these rejects straight to a file.

There is a special type of log event generated if a reject-handling link processes any rows. You can use DSGetNewestLogId() or dsjob -lognewest to search for this kind of log event specifically.