April 21, 2006 at 10:23 am
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.
April 21, 2006 at 10:52 am
Then either use an command line unicode converter through the Execute process task or if you have access to the file output application , modify it to replace all non ascii chars by their unicode "code" (ie.\u23234)
hope this help .
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply