Skip to Content
0
Dec 29, 2018 at 01:51 PM

SAP Data services converting decimal point into Comma while writing data

660 Views Last edit Dec 29, 2018 at 01:57 PM 2 rev

Hi Experts,

I am trying to write/load decimal data type data into .csv files and Salesforce tables/api using data services 4.2 SP 10.

Data services converting the decimal field value from decimal point to comma resulting in following situation -

1. Target CSV File : Data is getting wrongly written. Ex: 1,234 instead of 1.234.

2. Target Salesforce table : Job is failing as Salesforce decimal/double field can't accept comma(,) in it.

We tried checking the locale codes from locale selector but nothing got resolved. snapshot of the current setting is also embedded below.

Could you please help by providing some guidance here.

Many Thanks!

Kkam

Attachments

xapg0.png (19.5 kB)