Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'ClGeClie'
- From: "Christiano" <cdonke@xxxxxxxxxxxxxxxxxx>
- Date: Fri, 4 Jul 2008 10:56:41 -0300
I have 3 tables:
Clientes
Gerenciadoras
ClientesGerenciadoras..
The first lists all the clientes
The second the companies
The 3rd is a relation table n:n that crosses those 2 other tables with
foreign keys
When i'm copying these with DTS (with the Copy SQL Server Objects method),
at 96% it crashes, returning the message in the title...
The tables are all consistent... all data are valid...
what can I do to solve this???
the code generate codes and DTS config are following:
------------------------------
CREATE TABLE [dbo].[Gerenciadoras](
[GereCodi] [int] IDENTITY(1,1) NOT NULL,
[GereNome] [varchar](50) COLLATE Latin1_General_CI_AS NULL,
CONSTRAINT [PK_GereCodi] PRIMARY KEY CLUSTERED
(
[GereCodi] ASC
) ON [PRIMARY]
) ON [PRIMARY]
--------------------------------
CREATE TABLE [dbo].[Clientes](
[ClieCodi] [int] IDENTITY(1,1) NOT NULL,
[ClieNome] [varchar](100) COLLATE SQL_Latin1_General_CP850_CI_AI NULL,
[ClieCNPJ] [varchar](20) COLLATE Latin1_General_CI_AS NULL,
[cliegere] [int] NULL,
CONSTRAINT [PK_ClieCodi] PRIMARY KEY CLUSTERED
(
[ClieCodi] ASC
) ON [PRIMARY]
) ON [PRIMARY]
------------------------------
CREATE TABLE [dbo].[ClientesGerenciadoras](
[ClGeClie] [int] NULL,
[ClGeGere] [int] NULL
) ON [PRIMARY]
GO
USE [EscoltaOnline]
GO
ALTER TABLE [dbo].[ClientesGerenciadoras] WITH CHECK ADD FOREIGN
KEY([ClGeClie])
REFERENCES [dbo].[Clientes] ([ClieCodi])
GO
ALTER TABLE [dbo].[ClientesGerenciadoras] WITH CHECK ADD FOREIGN
KEY([ClGeGere])
REFERENCES [dbo].[Gerenciadoras] ([GereCodi])
------------------
DTS:
Create destination objects with include dependent objects and extended
properties checked (already tried with drop first check and unchecked),
copy data replacing ,
use colation,
copy all objects,
not using default options, instead i'm using the 1st and 3rd security
options.
.
- Follow-Ups:
- Prev by Date: sql xml bulkload using dts
- Next by Date: Re: dineed help for sql server 2000
- Previous by thread: sql xml bulkload using dts
- Next by thread: Re: Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'ClGeClie'
- Index(es):