DSXchange

Hi,

In my job I am generating the Row Number Column when reading from a sequential file by setting the stage's Row Number Column property.

I get a warning in the director that says -

When checking operator: When binding input interface field "RowNum" to field "RowNum": Implicit conversion from source type "uint64" to result type "int32": Possible range limitation.

The column passes through quite a few stages without any issues before it reaches the final transformer stage, where the warning is shown.

I have ste the data type of this column to Integer everywhere and I have RCP on.

Can anyone tell me why this warning appears? Also a way to get rid of this warning.

Regards,

The Bird.

The message itself says it all. Check the schemas rather than the "SQL" column definitions. At one point you have the column declared as an unsigned long integer (uint64); subsequently you load that value into a column designated as a signed integer (int32). The warning alerts you to the fact that not every uint64 can be stored in an int32.