Difference in Sequential File stage between DS 7.5 and 8.1

[Jamesliu]

I am using Sequential File stage (read from a text file) to read a varchar field with hex value like '0000CF' into an integer field. This works good in DS 7.5, but not work in 8.1. Anyone knows what caused it and how to fix?

Thanks!

[ray.wurlod]

Welcome aboard.

You've been relying on a bug in version 7.5 which has been fixed in version 8.1. That value is simply not an integer. You could read it as VarChar and convert from hex within a Transformer stage or, perhaps, an External Filter stage.