APT_Decimal::operator=: warning

[dsdevlr]

I seached the forum for this warning but didn't find what I am looking for.

I am moving a filed RSLT_TXT varchar(255) nullable from source table to the filed RSLT_TXT varchar(255) nullable in the target table.

Job is throwing the following warning

Rslt_Trn,0: Numeric string expected of the appropriate decimal precision for input column 'RSLT_TXT'. Use default value.
Rslt_Trn,0: APT_Decimal::operator=: the source decimal has even precision, but non-zero in the leading nybble, or is too large for the destination decimal.

Data contains strings, numeric and decimal values.

I am not able to fix this problem..pl help..

[chulett]

What exactly did you search for? An exact search for "non-zero in the leading nybble" found 11 other matches, none of them helped at all?

[dsdevlr]

Yes, Craig,

None of them are helpfull for me. I am just trying to move a filed from source to target no calculations, no transformations. It's a varchar with width 255 on both ends wondering why this warning is coming. none of the vaslues in the source filed are greater than 200 in length.

[chulett]

That's... odd, so no clue why it thinks you've got a decimal on the target end? When I've seen unexplainable things like this, I generally delete the stage in question from the job and set it up again from scratch and that typically resolves the issue.

Worth a shot here.