Decimal separator issue in SAP Data Services 4.2

[Former Member]

Hi,

Since we migrated from SAP Data Services 4.0 to 4.2 we encounter an issue in text files generated by Flat Files Format (without any structure - empty FF).

With the same job on BODS 4.0 platform we had a comma as decimal separator and on the 4.2 platform we have a dot.

We have check regional settings on old and new server and have the same configuration.

We added instruction "Decimal_separator = ," in DSConfig.txt without any result.

The OS of old platform is Windows Server 2008 and on the new one Windows Server 2012.

Did someone already encounter this issue ?

Thanks for your help.

[Former Member]

Hi,

can you try using to_decimal($Value,<decimal separator>,<Thousands separator>,<scale>)

[Former Member]

Hi,

Thanks for your answer. But we already test that option and It has no impact.