Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    [SOLVED] DataMigrator: How to handle Invalid data in source delimited file
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] DataMigrator: How to handle Invalid data in source delimited file
 Login/Join
 
Member
posted
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,
 
Posts: 8 | Registered: August 05, 2015Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Look here


"There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott
 
Posts: 1092 | Location: Toronto, Ontario | Registered: May 26, 2004Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    [SOLVED] DataMigrator: How to handle Invalid data in source delimited file

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.