The Data Integration Service creates reject files for each target instance in the mapping. It creates reject files in the target reject file directory.
Configure the target reject file directory in the run-time properties for a flat file or relational target in a mapping. By default, the Data Integration Service creates reject files in the directory defined by the RejectDir system parameter. The Data Integration Service names reject files after the target instance name. The default name for reject files is
<file_name>.bad
.
When the Data Integration Service creates multiple partitions for a target, the Data Integration Service creates a separate reject file for each partition named
<file_name><partition_number>.bad
. For example, three partitions might write to reject files named MyOutput1.bad, MyOutput2.bad, and MyOutput3.bad.