title: Special characters are converting into some other type while loading into ms sql from flat file source using SSIS
body: <p>I am trying to load data like "7704ó " into ms sql table through SSIS from flat file. But after loading the data what apper in the table is like "7704¢ ". I tried converting the code page from 1251 to 65001(UTF-8) and changing the datatype to WSTR type but still no use and flooded with the error messages. Please anyone help resolving this.</p>