This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(243.2, 20%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDP%3C/text%3E%3C/svg%3E)
Hello,
I have a "Flat file" from which I'm getting data to pass to "Destination DB" through an "SSIS Data Flow". Once I run the package, and query the DB destination I realize there're wrong data values on the destination. (schema attached and wrong value marked in yellow)
For example, when IDCLIENT=1000 I get NAME ='AntÃ'nio' and I should get NAME = 'Antônio' as it is in the source.
I know is an encoding-related issue. but don't know how to fix it. Any help will be very appreciated!!
It is almost obvious, that an UTF-8 file is interpreted as a regular one. Check if you can force the flow to interpret it using UTF-8 encoding (code page 65001).
Or maybe try re-creating the source file using "UTF-8 with signature" or "UTF-8 with BOM" encoding.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 26%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
Hi @Diogo Pedro Melo ,
Go to the Flat File Connection Manager.
It has three options to control data encoding and Unicode characters:
Please see below.
Hi @Diogo Pedro Melo ,
Please configure the Flat File connection manager.
Specify the file, locale, and code page to use. The locale is used to interpret locale-sensitive data such as dates, and the code page is used to convert string data to Unicode.
Regards，
Zoe
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Do you have further question on this , could we offer more support?
If this helps on your issue, you could mark it as answer so other user with similar problem could see this easier. :)