chulett wrote:Doesn't that depend on your "Reject Mode" setting? From the docs:
Reject Mode
Allows you to specify behavior if a read record does not match the expected schema. Choose from Continue to continue operation and discard any rejected rows, Fail to cease reading if any rows are rejected, or Save to send rejected rows down a reject link. Defaults to Continue.
I've tried all three. The data in my case is not being treated as a reject.
Also check that you don't have a message handler masking the default behavior. The job log will tell you about Attached Message Handlers (if you have any).
Mike wrote:Also check that you don't have a message handler masking the default behavior. The job log will tell you about Attached Message Handlers (if you have any).