Posted: Tue Feb 19, 2008 1:47 am
Do some investigation. Create a throw-away job to read the source data and report the actual length of this field (using the Len() function). Just out of curiosity, also report the number of bytes (using the ByteLen() function). Send the result into a delimited text file.
Process a few rows, in particular some of the ones that threw the error, and let us know what you see.
Then enhance the throw-away job with part of the expression (say the Trim() function initially) and report that and its length. Then the substring.
Process a few rows, in particular some of the ones that threw the error, and let us know what you see.
Then enhance the throw-away job with part of the expression (say the Trim() function initially) and report that and its length. Then the substring.