I have been charged with adding error handling to an existing procedure. This is complete but now the user says that if the value in Column 5 equals xxx, then Column 7 value cannot be null. I think I will need a conditional split prior to the data conversion step. Then send that row to the error file and continue to process other rows. Can I compare the value of two columns in a conditional split? If so, an example would be helpful.
