Implicit conversion from source type "decimal[38,10]&qu
Posted: Mon Feb 16, 2009 9:56 am
I am getting following warning message for a copy stage in the job when i am running.
Rej_Cp_T5_SalesChannels: When checking operator: When binding output schema variable "outRec": When binding output interface field "ORD_SEQ_NBR" to field "ORD_SEQ_NBR": Implicit conversion from source type "decimal[38,10]" to result type "int16": Possible range/precision limitation.
The warning is coming for this column, the copy stage input column ORD_SEQ_NBR Decimal length 38 scale 10 nullable Yes.
Output column ORD_SEQ_NBR Smallnt length 5 nullable Yes.
Please help on eliminating this warning, without suppressing it.
Thanks.
Rej_Cp_T5_SalesChannels: When checking operator: When binding output schema variable "outRec": When binding output interface field "ORD_SEQ_NBR" to field "ORD_SEQ_NBR": Implicit conversion from source type "decimal[38,10]" to result type "int16": Possible range/precision limitation.
The warning is coming for this column, the copy stage input column ORD_SEQ_NBR Decimal length 38 scale 10 nullable Yes.
Output column ORD_SEQ_NBR Smallnt length 5 nullable Yes.
Please help on eliminating this warning, without suppressing it.
Thanks.