SSIS And UTF 16 Big Endian Text File

Hi,

I'm attempting to import a UTF-16 BE (Big Endian) encoded text file via SSIS. The column delimiter is comma, and the row delimiter is a {LF}.

When I select the file in the "Flat file connection manager editor", the Unicode checkbox is automatically checked, the Format option is "Delimited"; I change the header row delimiter to {LF}, and check the box 'column names in first data row.

I then click on the "Columns" tab, change the row delimter to {LF}, and hit refresh, however the error comes up that the delimiter could not be found in the file.

The file does contain the UTF-16 BE Byte Order Mark.

If I convert the file to UTF-16 LE (Little Endian), the file is read successfully, with {LF} being detected as the row delimiter.

Two questions:
- Does SSIS support import of text files that are UTF-16 BE encoded?
- If yes, how can I get this to work.

I found an error message in the Books Online, when I searched for Endian
"HResults.DTS_E_UTF16BIGENDIANFORMATNOTSUPPORTED Field - The file format of UTF-16 big endian is not supported. Only UTF-16 little endian format is supported."
Namespace: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)


However, I'm not sure as to what the above error applies to.



Thanks,
RS