I'm trying to import a ANSI format file which contains a name Portomeñe. But when I import it using the DAta flow task, it is importing as Portomeï¿½e. The special character ñ corrupting after the import. The data type of the column where I'm importing the data (whole row) is varchar(7000). Please suggest how to fix this issue. I'm in urgent need of fixing this issue.
Thanks in advance...
I managed to import this using a csv as source and making sure the data type is Unicode string: Unicode string [DT_WSTR]. My string had a maximum of 4000 characters long.
answered Jul 08, 2017 at 10:20 PM