从sql2000导入数据到sql2005的问题

两个数据库里都有下面的表:

CREATE TABLE [dbo].[Partner](
 [PartnerID] [int] IDENTITY(1,1) NOT NULL,
 [Name] [nvarchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
 [FullName] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
 [City] [nchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
 [Email] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
 [Contact] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
 [Address] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
 [Tel] [char](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
 [Description] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
 [PostCode] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
 [Fax] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
 [Website] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
 [Capacity] [int] NULL,
 [Password] [nvarchar](12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
)


在2005的Management Studio中,从2000数据库导入这个表的数据到2005,出现下面的错误,不知何故啊
- Validating (Error)
Messages
Error 0xc02020f4: Data Flow Task: The column "Tel" cannot be processed because more than one code page (936 and 1252) are specified for it.
 (SQL Server Import and Export Wizard)
 
Error 0xc004706b: Data Flow Task: "component "Destination - Partner" (57)" failed validation and returned validation status "VS_ISBROKEN".
 (SQL Server Import and Export Wizard)
 
Error 0xc004700c: Data Flow Task: One or more component failed validation.
 (SQL Server Import and Export Wizard)
 
Error 0xc0024107: Data Flow Task: There were errors during task validation.
 (SQL Server Import and Export Wizard)
 

posted on 2005-10-27 17:57  David  阅读(7960)  评论(10)    收藏  举报