After you find a reject file, you can read it using a text editor that supports the reject file code page.
Reject files contain rows of data rejected by the writer or the target database. The Data Integration Service writes the entire row in the reject file. However, the problem usually centers on one column within the row. To help you determine which column caused the row to be rejected, the reject file contains indicators that give you more information about each column.
Reject files contain the following indicators:
Row indicator
The first column in each row of the reject file is the row indicator. The row indicator defines whether the row was marked for insert, update, delete, or reject.
Column indicator
Column indicators appear after every column of data. The column indicator defines whether the column contains valid, overflow, null, or truncated data.