none
dtexec Error Message not support Traditional Chinese RRS feed

  • 問題

  • System:
    SQL 2008 & Windows Server 2008 Traditional Chinese version.

    Problem:
    Use dtexec at SQL Agent. View the history at the SQL Agent Job, the log message shows lots of ??????. It seems like dtexec generate the log in non-unicode format. Is it a known bug on the traditional chinese version? Any work around (not reinstalling the Windows & SQL to English version) to make it shows at least the English error message rather than ???????


    2009年3月23日 上午 03:42

解答

  •  
    myQuestion 表示:

    System:
    SQL 2008 & Windows Server 2008 Traditional Chinese version.

    Problem:
    Use dtexec at SQL Agent. View the history at the SQL Agent Job, the log message shows lots of ??????. It seems like dtexec generate the log in non-unicode format. Is it a known bug on the traditional chinese version? Any work around (not reinstalling the Windows & SQL to English version) to make it shows at least the English error message rather than ???????



    Hi myQuestion,
    Based on my experience, this may be cause of the fields type.
    Please check the all fields, please change the fields type which is varchar to nvarchar if we need this fields to support Traditional Chinese character.
    2009年3月26日 上午 09:49
    版主

所有回覆

  • Hello,

    Can you post the error message? Thanks!

    Microsoft Online Community Support
    2009年3月26日 上午 02:07
  •  
    myQuestion 表示:

    System:
    SQL 2008 & Windows Server 2008 Traditional Chinese version.

    Problem:
    Use dtexec at SQL Agent. View the history at the SQL Agent Job, the log message shows lots of ??????. It seems like dtexec generate the log in non-unicode format. Is it a known bug on the traditional chinese version? Any work around (not reinstalling the Windows & SQL to English version) to make it shows at least the English error message rather than ???????



    Hi myQuestion,
    Based on my experience, this may be cause of the fields type.
    Please check the all fields, please change the fields type which is varchar to nvarchar if we need this fields to support Traditional Chinese character.
    2009年3月26日 上午 09:49
    版主
  • Here is the dtexec messgae from English & Chinese version:

    =========================================================================================================
    Executed as user: DEMO\SYSTEM. Microsoft (R) SQL Server Execute Package Utility  Version 10.0.1600.22 for 32-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started:  9:42:53  DTExec: The package execution returned DTSER_SUCCESS (0).  Started:  9:42:53  Finished: 9:42:58  Elapsed:  4.407 seconds.  The package executed successfully.  The step succeeded.
     
    =========================================================================================================
    以下列使用者的身分執行: DEMO2\sqladmin。Microsoft (R) SQL Server ????????  Version 10.0.1600.22 for 64-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    ???:  8:00:01  DTExec: ?????? DTSER_SUCCESS (0)?  ???:  8:00:01  ???: 8:00:09  ????:  8.112 ?.  順利執行封裝。.  步驟成功。
    2009年3月30日 上午 08:06