How to capture reject records along with reject reason

[Anonymous]

Hi,

I am trying to implement a requirement. I want to capture error records along with reason.
Eg : I loading data from SQL server to SQL server DB doing some validations to data based on vallu dations some records are getting rejected, I want to capture rejected records and reject reason ( error message ).
I tried to clear die on error check box it is showing two columns error message and trace level. What I have to provide values for those fields.
Any help is highly helpful for me...


Regards,
MS

[Anonymous]

Hi
What rule are you using to validate the data? take a look at tSchemaComplianCheck component, it can be used to do the validation before inserting.

Regards
Shong

[Anonymous]

Thanks for quick response,

Inserting data into Target DB is fine but my requirement is for rejected records, some records are rejecting based on null condition,..etc I want to capture the reason for rejection ( something like error message).

Regards,
MS

[nfz11]

What database component are you using?  The reject row from a tDBOutput component contains the error message and error code.  You can capture it from there and do what you want with it.

[Anonymous]

Hi
You can link a reject flow after tDBOutput component, to use reject flow, you need to unchecked the 'die on error' and 'use batch' options.

Regards
Shong