Posted: Wed May 23, 2012 8:24 pm
As stated, our workaround was to split the transformer into 2 stages.
However, we encountered another problem, to do with the last 6 Text stage variables, which was resolved by replacing the "setnull()" with a text string (e.g. "NULL FLAG"), and in the output derivation use:
If svCPItxt="NULL FLAG" Then SetNull() Else scVPItxt
I went back to an earlier version of the job before we split the transformer, and replaced the "SetNull()" functions in the stage variables... and it worked!
Note that I had a similar problem with using SetNull() in loop variables.
Lesson learned:
in v8.5.0.1, do not use SetNull() in Stage Variables or Loop Variables.
However, we encountered another problem, to do with the last 6 Text stage variables, which was resolved by replacing the "setnull()" with a text string (e.g. "NULL FLAG"), and in the output derivation use:
If svCPItxt="NULL FLAG" Then SetNull() Else scVPItxt
I went back to an earlier version of the job before we split the transformer, and replaced the "SetNull()" functions in the stage variables... and it worked!
Note that I had a similar problem with using SetNull() in loop variables.
Lesson learned:
in v8.5.0.1, do not use SetNull() in Stage Variables or Loop Variables.