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 ?