Conversion error calling conversion routine decimal_from_str

Hope · Post by **Hope** » Wed Aug 08, 2007 12:30 pm

My Sourcedata is Varchar and Target data is Decimal. I am using stringtodecimal(col1) in the Transformer.I get the following warnings."Conversion error calling conversion routine decimal_from_string data may have been lost" .

Can anyone please help me how to get rid of this warning

chulett · Post by **chulett** » Wed Aug 08, 2007 12:48 pm

Source size? Target size? It is telling you that your source is 'bigger' than your target and so may lose data in the conversion.

Hope · Post by **Hope** » Wed Aug 08, 2007 12:51 pm

My source length is bigger than Target.I have 241 columns. The datalength for all the columns is greater than target length.

Hope · Post by **Hope** » Wed Aug 08, 2007 12:51 pm

My source length is bigger than Target.I have 241 columns. The datalength for all the columns is greater than target length.

Hope · Post by **Hope** » Wed Aug 08, 2007 1:37 pm

My source length is bigger than Target.I have 241 columns. The datalength for all the columns is greater than target length.

ArndW · Post by **ArndW** » Wed Aug 08, 2007 2:56 pm

You cannot get rid of this warning altogether, but you can set up a job level or project level handler for the message and either deprecate it (turn it into an informational message) or remove it from the logs altogether.