I created a flow with sql server source and target table. In the source table, one of the column data type is ‘A12’ and the corresponding mapping target table column data type is ‘I11’. I want to insert the format error data into separate table, I used “Record Logging” tab on the Flow Properties, we have options in there to capture rejects. Please find the attached screenshot .

When I run the job, I am not able to see the format error data into format error table ‘flow01_formaterr.ftm’ and the same – none of the “Record Logging” tables are not getting inserted.

Note:

Version – 7.7.03
Source table – SQL Server
Target table – SQL Server
Record logging tables – Flat File
Prior to load – Truncate/Insert record

This message has been edited. Last edited by: Tamra,

A Data Flow doesn't trap Format Errors as stated in the DMUG:

Format Errors
Logs transactions rejected due to a format error. (Format errors only apply to Direct Load Flows.)

So if the source is a single table try using a Direct Load Flow.

Hi Clif,

I tried in direct load data not loaded into format error table.

Simply getting not able to convert for the field "Filed1"

Thanks,
MAdhu

Please open a hottrack case and upload your Direct Load Flow, source and target synonyms, and some sample erroneous data.