Hi,
I am exporting a table data to a flat file using DTS Package. Some of the
columns in the table contain special characters. After the data is exported,
the special characters in the flat file are not same as the special
characters in the columns of the table. How does this happen? How can I
resolve this?

Regards,

Sevugan.C

Hi Sevugan,

"Sevugan" <Sevugan (AT) discussions (DOT) microsoft.com> schrieb im Newsbeitrag
news:C54C20E3-86D7-4D28-B56F-43708A1B841C (AT) microsoft (DOT) com...
which file format did you specifiy for the export file?
The default type is ANSI which may result in different presentation of
extented/unicode characters.
If your database datatype is unicode, then you should set the file format to
unicode also.
You can change this under the properties button of the file connection.

Helge

Hi Rutz,
The datatype of the field is char. But that field contains unicode
characters.
I set the file type to Unicode under the file properties in the DTS Package.
Still I am getting the same result(Some characters are getting converted
into others). How can I resolve this? Is there any other way?


--
Sevugan.C


"Helge C. Rutz" wrote:

Hi Sevugan,

"Sevugan" <Sevugan (AT) discussions (DOT) microsoft.com> schrieb im Newsbeitrag
news:27B5F0C2-A009-41CE-81F6-3403290D1DB9 (AT) microsoft (DOT) com...
when you really use char as datatype, then the representation of the data
is always influenced by the collation, because the byte values represent
different characters in different collations.
You can try to get the right output when you specify a SQL statement as
transform source, where you specify the collation you need for your data.

Helge