June 25, 2009 at 9:43 am
Hi All,
I have a fixed width text file which for the most part contains normal unicode chars but some fields are in an ASCII format. This issue is that when I import from this file the ASCII chars are removed so for example;
Origional File
Column1 Column2
12323 ][
Imported into table
ColumnName1 ColumnName2
12323
As you can see its as if it strips it out. I have a function (SQL) which will convert the ASCII but I need to import first in order to convert. Please help.
June 25, 2009 at 3:08 pm
Do you think changing a code page options in the flat file conncetion would help?
June 25, 2009 at 6:30 pm
In the editor for the flat file connection, what are the datatypes for the input columns?
June 27, 2009 at 11:25 am
Hi, I am using NVARCAHR 255 in my destination tables, I have tried sting, byte stream and T Weaterun (unicode)
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply