Post reply

Values from config table returning set in package in Chinese

  • October 16, 2014 at 11:33 am

    #294216

    I have a package that runs fine when I run it on my dev enviroment but when I try to deploy it to another server I get the following error:

    [Execute SQL Task] Error: Executing the query "䤠⁆塅卉協匨䱅䍅⁔‪剆䵏猠獹漮橢捥獴圠䕈䕒漠橢捥彴摩㴠传䩂䍅彔䑉丨搧潢倮慬散晏敓癲捩䍥摯❥䄩䑎琠灹⁥..." failed with the following error: "Incorrect syntax near '⁆'.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

    Obvioulsy I dont have my tsql in chinese. Is there a setting where this is set?

  • October 16, 2014 at 12:06 pm

    #1752936

    A little more info:

    I've noticed that when I change the datatype of the [Configured Value] column to nvarchar I have no issue but when I change it to varchar I get the error.

  • October 16, 2014 at 2:43 pm

    #1752982

    Apparently there was a setting that when I used varchar it would be returned in Chinese. When I queries the same table in SSMS, I saw it in English. Oh well, nVarchar it is!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply