Hi I am trying to stop the execution of a job if in a transformation that reads rows from text file appears 15 lines with errors.
Example if into a integer field appear a string (it happens in the real life). I separate the rows with error into a diferent stream and I have just use a secuence for count the number of lines and after a filter rows to take the number 15th to a new text field with the intention of use file exist after that transformation, the things that happend to me is that when the transformation runs the text field was created, empty but created... so all time the job stop.

I supose that there have to be another form to do that but i dont know how, if you can tell me another form or say me how can i do it better i will be very pleased.

Regards Saúl