![Smile :)](./images/smilies/icon_smile.gif)
My job design is like:
sequencial file stage=>transformer=>dataset
the sequencial file is fixed-width, timestamps are in the format: YYYYMMDDHHMISS, for example, 20070227124900 and are filled with spaces where optional.
The SQL Type in the sequencial file stage is VARCHAR(14). I did the conversion in the transformer stage, the logic is like:
1. First trim trailing spaces and store into a stage variable say SVTimestamp
2. if SVTimestamp = '' Then SetNull()
3. If IsValid("Timestamp", StringToTimestamp(SVTimestamp,"%yyyy%mm%dd%hh%nn%ss") Then StringToTimestamp(SVTimestamp,"%yyyy%mm%dd%hh%nn%ss") Else SetNull()
If the incoming timestamps are invalid, e.g. 20070227124961, the conversion in the IsValid will produce a warning in the job log.
Am I right? How can I eliminate the warning from the job log? Appreciate your help.