I need to able to import data from US and NON US flat files in to SQL. The tables have nvarchar columns. When I open the flat file(.txt file) from the ftp server I am able to see European Charaters(Mühlstr. 71) but when I load them using DTS into SQL table I see the data as Mühlstr. 71. Even changing the connection property to unicode(File type) did not help.
When I opened the file and saved it as unicode file and I import the data the data looks good. How can I import this file with out messing up the data. I even tried adding a step in DTS where I transform the file as unicode(Source ascii file and Destination unicode file) and that did not solve my problem. Any help is appreciated.
Thanks.