"Unicode" in Flat File Connection Manager

Hello,

Does anybody know, how to load unicode text file using Flat File Source Task?

I set "unicode" option on the general tab of the Flat File Conn. Manager.

(my text file is comma delimited, the default row delimiter is {CR}{LF})

but on the Column tab I see only one row in one column (I have several rows and columns in the flat file).

How to see them all ?

I appreciate any help !

Anna

Hi Anna,

Do you know if your file is encoded as UTF16 or UTF8. If it is UTF8 uncheck the Unicode flag ans select an appropriate code page for UTF8.

Thanks,

Bob

|||

Hello Bob,

I did it - I set Code page to 65001.

It works now.

Thank you!

Anna