[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?
RajeshThis message has been edited. Last edited by: Tamra,