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,
"There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott
|Powered by Social Strata|