Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-05-04 : 07:51:01
|
| Sevugan writes "I am exporting a table data to a flat file using DTS package(Scheduled Package). One of the columns in the table conatains special characters. After it is exported, the special characters in the flat file are different from the one in the table.How can I resolve this?" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-05-04 : 07:54:19
|
| Change the file format from ANSI or OEM to Unicode (click Properties button when you create or edit the text file connection). Warning: this will double the size of your file, but it will preserve special characters.You should also check the datatype for that column, if it is nchar or nvarchar, then you definitely need unicode. |
 |
|
|
|
|
|
Special Characters are getting converted during export