>there are 2 SQL server in my company.
>one is 7.0 used code Page 1252 . the other one is 2000 used Chinese_taiwan Code Page.
>
>if I DTS the data from the SQL 7.0 server to 2000 server
>all the chinese charater can't see after DTS .
>
>how can I convert the data to fit to the 2000 server collate during DTS ?

I believe the most recent SP of SQL Server 2000, SP2 I believe, fixed some collation issues when using DTS.

BOb