Optional: Rejecting records that contain errors

When the Azure Storage connector includes a reject link, you can configure the connector to send records that cannot be parsed to the target stage on the reject link. If you configure the connector to send records to the reject link, the job completes even if data is rejected.

Procedure

  1. On the job design canvas, add and configure a target stage to receive the rejected records.
  2. Right-click the Azure Storage connector and drag to create a link from the Azure Storage connector to the target stage.
  3. Double-click the connector to open the stage editor.
  4. Set the Reject mode property to Reject
  5. Set up the Reject link:
    1. On the Output page, select the link to the target stage for rejected records from the Output name list.
    2. On the Properties page, set Is reject link property to Yes.
    3. If runtime column propagation is not enabled, set up column definitions for the link. Include one VarBinary column and, optionally, a column of a string data type to contain error messages for the rejected records.
  6. Click Ok, and then save the job.