Migrating SQL server 2000 database to SQL server 2005 with Japanese alphabets

[VaibhavJ]

Hello everyone !!! I want to migrate SQL Server 2000 database onto SQL Server 2005 database. The original SQL Server 2000 database tables contain some Japanese characters and I need to transfer them as well to SQL Server 2005 database. For this purpose I have done following things. 1. Exported all tables data to a excel sheet. (by choosing Microsoft Excel 97/2000) 2. But when I try to import this data to SQL server 2005 I am getting following error It verifies it. (error) Message Error 0xc02020f6: data flow task: The character-string data type of the Unicode form and the character-string data types of the form other than Unicode cannot be converted by the row "Description". (SQL Server import and export wizard) Error 0xc004706b: "Component" conversion of the data flow task ahead- tblCMSTypeMaster "(26)" failed in the verification, and the verification state "VS_ISBROKEN" was returned. (SQL Server import and export wizard) Error 0xc004700c: data flow task: It failed in the verification because of one or more components. (SQL Server import and export wizard) Error 0xc0024107: data flow task: The error occurred while verifying the task. (SQL Server import and export wizard) I guess this problem is related to importing of Japanese characters. I am stuck with this problem. Any solution/suggestion on this issue is greatly appreciated. Thanks in advance. Thanks & regards, Vaibhav