Focal Point
[SOLVED] DataMigrator: How to handle Invalid data in source delimited file

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/1381057331/m/5267055086

February 01, 2016, 10:13 AM
Rajesh T
[SOLVED] DataMigrator: How to handle Invalid data in source delimited file
Hi

I have created an invalid data (placed alpha numeric value in a integer column) in the source delimited file and ran the flow. Flow ran to success.
It skipped the row throwing an error message ( : FORMAT ERROR: Record 1 , Column 91 ) in the log and loaded rest of the rows into the target table.
Flow return code is 0.

How can I fail the flow in this scenario if there is a invalid data?
How can I capture the error message and email it to file provider?

Rajesh

This message has been edited. Last edited by: Tamra,
February 02, 2016, 08:12 AM
dhagen
Look here


"There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott