Page 1 of 1
TI process should not load data if it throws error
Posted: Thu Aug 25, 2011 9:01 am
by swati_phadtare
Hi ,
While loading data from flat file through TI process if it throws any error then it should not load any data to cube.
Kindly help me in coding this.
Thanks & Regards
Re: TI process should not load data if it throws error
Posted: Thu Aug 25, 2011 9:12 am
by Steve Rowe
Your best bet is to trap "any errors" in the metadata tab before starting the data tab. Then if you find errors you can processbreak/quit at the end of the metadata.
Re: TI process should not load data if it throws error
Posted: Thu Aug 25, 2011 10:06 am
by Christopher Kernahan
For individual items that have errors, you can use ItemReject('message'); which will skip the particular data line and also output a message to the Message Log.
Re: TI process should not load data if it throws error
Posted: Thu Aug 25, 2011 10:10 am
by David Usherwood
If you don't want _any_ data from the feed to be left in the cube, count the errors and clear the destination in the epilogue if the count is positive.