SETLOCALE

The SETLOCALE command enables you to override the default locale for OLAPICMD. The default locale for OLAPICMD is UTF-8 (Unicode).

Although a script file saved from Integration Services Console does not have the UTF-8 signature, OLAPICMD nevertheless reads the script as UTF-8.

If you create a script file in Microsoft Notepad and save the script file as a UTF-8 file, you do not need to use the SETLOCALE command to select a locale. You can use the default locale. If you choose to select a locale, you must select one that is UTF-8. A native locale causes load operations to fail.

If you create a script file in Microsoft Notepad and save the script file as an ANSI file, you must select a native locale. A UTF-8 locale causes load operations to fail.

If you intend to enter Integration Services Shell commands manually (rather than executing them through a script) on a native computer, you must select the appropriate native locale using the SETLOCALE command. Failure to do so will cause load operations to fail.

Syntax

SETLOCALE <LANGUAGE_TERRITORY.CODEPAGE@SORT>
SETLOCALE .UTF8@default

Examples

SETLOCALE Japanese_Japan.MS932@Binary
SETLOCALE .UTF8@default