DSXchange

Hi ,



When I write data (input filed (9,2) ) to XML output stage (target filed (9,2)), the trailing zeros were truncated. I did check with dataset as output stage, it retained trailing zeros.

Can you please let me know how to hande this before I send data to XML.

Thanks
Sri

Define the field as varchar of appropriate length in target XML output stage

Thanks anbu for your reply.It did work, but I need to truncate leading zeros. when I tried with decimaltostring function it is truncating both leading and trailing zeros.

sri75 wrote:Thanks anbu for your reply.It did work, but I need to truncate leading zeros. when I tried with decimaltostring function it is truncating both leading and trailing zeros.

You might want to post the syntax you were using for this.