Applies to:  All products, releases 6.x and Up

Error:

Operation failed.
Details:
This add-in requires Excel to use the system separators.

 

Background

"Separators" are characters such as the decimal symbol (.), digit grouping symbol (,) etc. 

You can set them in Windows Control Panel (Region and Language) and they will apply to all programs.

You can also set them in Excel (Decimal separator and Thousands separator in the Advanced Options dialog, in the Editing section).

Although you can make Excel's thousands separator and decimal separator different from the Windows settings, the DTS software requires that you NOT do this. 

Solution:

1. Click File » Options » Advanced
2. Under Editing options, put a check mark in the box labeled Use system separators.