DSXchange

In version 8x, If I use SetNull() function in the transformer to set the value of a column to null, it is setting the column value to "NULL" but not the actual null like the @NULL function in Basic Transformer.

Does any one know why? Or how to get the actual NULL inserted?

Thanks.

No it isn't. Something you are doing downstream of the transformer stage is converting the true null to the representation "NULL" - probably a null field value, my guess is in a Sequential File stage's input link metadata.

IS there a SetNull() function in a server job Transformer stage?