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 |
|
ckdong
Starting Member
2 Posts |
 Posted - 2009-07-31 : 16:29:04
|
| Hello.I have unicode data in a ntext field.I am attempting to use DTS to export the data to flat files.The table stores email messages in various languages. I would like to export each message to a file for archival/data-retention purposes.With the DTS package, I am able to create a file for each record of ntext data. The file names are based on data in a nvarchar column. I am able to have files properly named with Japanese or Chinese or accented characters.Unfortunately, the file contents have question marks in place of Japanese or Chinese characters.How can I export the data to flat files and preserve the language? ie. not get question marks?When I run a query in Query Analyzer from the actual server (Win 2000 Server), the data appears as blocks.When I run the same query from my desktop computer (Win XP), the data appears as it should-- Japanese or Chinese, etc characters. I have no problem copying and pasting to Excel.I'd like to have all the information in Excel; however, there are over 70,000 records and I'm sure many of the messages are extremely large. At some point, Excel probably won't be able to take it.Microsoft SQL Server 2000 - 8.00.2148 (Intel X86)Standard Edition on Windows 2000 (Build 2195: Service Pack 4) Thank you very much.I appreciate any feedback and/or advice.Sincerely,ckdong |
|
|
ckdong
Starting Member
2 Posts |
Posted - 2009-08-12 : 10:14:14
|
| I found an error in the DTS package. It can now successfully export non-English text-- eg. Chinese and Japanese-- to flat files.In the actual Transformation task, under the write_file transformation properties, I changed the type from 'ansi' to 'unicode'. Thanks everyone for reading and considering my question.ckdong |
 |
|
|
|
|
|
DTS exporting ntext (unicode) data to flat files