两个数据库里都有下面的表:
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)
从sql2000导入数据到sql2005的问题
转载于:https://www.cnblogs.com/darzui/archive/2005/10/27/263296.html