Reprocessing Rejected Rows

When source rows are rejected, you can use Rejected Source Rows feature to ensure that they are written to a file with a similar format as the source. Use this file to complete processing of a DTS file whose rows were rejected because of error conditions.

To reprocess rejected rows

  1. Examine the Transaction Error report to determine the cause of the rejected rows.
  2. Determine the validity of the rejected rows. If a rejected row is valid it should not be reprocessed.
  3. Open the DTS file that rejected the rows.
  4. Create a copy of the DTS file using Save As and make your changes to the DTS file you just created.  
  5. Use the Configure Steps or Edit Formulas dialog boxes to correct the error condition that caused the rejected row.
  6. Change the source connection to the file or table you defined to contain rejected rows.
  7. Run the new job.

See also

About rejected row logging

Running a job

Evaluating a job

Transaction Error Report