Is it possible to cancel processing of a line in the ProcessInputRow method? I am doing some data assumptions with the CSV data coming in this function. I am setting the line value in a sub if any error occurs, then I will capture it in Process and then start writing the data in the staging table for approval. The problem is that the problem is that the row with the bad data is still written in the target table.
e.g. I have a line with string value 99-02-2010, which I try to add as a CDAT to a column of the like date:
line.ChangeDate = CDA (line value. The gate value (0). Ostring ()) '=> puts an exception
As stated, exception is thrown by me and written in the row in my forum table, but I have to do script work Processed this line by No way can be found. Any ideas?
Create a new output in your script works and paths for error output Bad lines (with a suitable error message column / description) Then bring them all into the path that you want to use.
Comments
Post a Comment