You can translate the question and the replies:

Special character issue through SSIS.

Hi all, we are using DENODO DB as a source and trying to pull data to SQL server using SSIS2014. we are facing special charcters issue. special characters are appearing as junk charcters. PFB DENODO data and SQL server data. ![https://drive.google.com/open?id=1t9Gvjcw-9_gzUwaX93r06fpXDTAZ5Tnt ](https://drive.google.com/open?id=1t9Gvjcw-9_gzUwaX93r06fpXDTAZ5Tnt) ![https://drive.google.com/open?id=1zUt-FcwKubKdl-wJv0OnkAcg1gIlvMxl](https://drive.google.com/open?id=1zUt-FcwKubKdl-wJv0OnkAcg1gIlvMxl)
SSIS
user
21-12-2017 02:56:08 -0500
code

4 Answers

Hi, To handle the special characters in the SQL Server, it is recommended to set the encoding of the database to "65001 UTF-8". To do this please edit the properties of the database and under the CodePage option select 65001 UTF - 8. If you are a customer with valid support user, you could raise a ticket so that our support team can help you. Hope this helps.
Denodo Team
22-12-2017 02:25:14 -0500
code
Hi, is there any way to handle in SSIS inetad of changing properties in SQL server
user
 Edited on: 02-01-2018 18:09:18 -0500
Hi, The CodePage option is availabe in the SSIS. You can select the UTF- 8 encoding there when you create the database under the properties section. If you are a customer with valid support user, you could raise a ticket so that our support team can help you. Hope this helps.
Denodo Team
02-01-2018 06:58:39 -0500
code
HI, we have tried that option as well. But still we are getting same error. we are able to load special charcters data succesfully. while creating DSN, we need to select UNICODE instead of ANSI.
user
 Edited on: 02-01-2018 18:09:18 -0500
You must sign in to add an answer. If you do not have an account, you can register here