You can define decimal and thousands separators in the numeric data area of the Column Format Settings dialog box. For the decimal separator, you can choose a comma or a period. The default is the period. For the thousands separator, you can choose no separator, a comma, or a period. The default is no separator.
To specify numeric separators, click Override Separators and choose a separator from the Decimal Separator and Thousands Separator fields. You can override one or both separators. When you override the separators, you must choose different options for each.
For example, the source data contains a numeric field with the following data:
Choose the period as the thousands separator, and choose the comma as the decimal separator in the flat file source definition.
For example, you want to output the data above to a file target with the following format:
Choose the comma as the thousands separator, and choose the period as the decimal separator in the flat file target definition.