Re: Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'ClGeClie'
- From: matteus <matteograd@xxxxxxxxx>
- Date: Mon, 7 Jul 2008 00:44:42 -0700 (PDT)
On Jul 4, 11:13 pm, "Christiano" <cdo...@xxxxxxxxxxxxxxxxxx> wrote:
thank you very much....
just one more thing...
the application that uses that database is 24-7 on...
can i somehow make this modification on the fly during the dts copy???
tks in advance...
christiano.
"matteus" <matteog...@xxxxxxxxx> escreveu na mensagemnews:62b79657-0137-46a1-8a2e-f36ddb915fbb@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On Jul 4, 3:56 pm, "Christiano" <cdo...@xxxxxxxxxxxxxxxxxx> wrote:
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.
Hi Christiano,
try to UNCHECK the 'Copy primary and Foreign Keys' Option of the copy
sql objects task, delete the costraints (pk and fk) and set the pk
field of the two entity-tables (customers and companies) to a simple
int field (i mean trasfomr it form an identity to a normal int)
If it works then attach an execute sql task to rebuild your
constraints and original table structure.
Hope this helps!
M.
no, you cannot modify a dts while it's running.
I gave you a hint on which could be the cause of dts failure... if
it's fail because of pk and fk i would rather investigate to find
another way to move data. i would never use this process (removing pk
and fk constraints and creating them after the data has moved) in
production.
Bye,
M.
.
- References:
- Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'ClGeClie'
- From: Christiano
- Re: Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'ClGeClie'
- From: matteus
- Re: Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'ClGeClie'
- From: Christiano
- Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'ClGeClie'
- Prev by Date: Re: import subset of text files in a directory
- Next by Date: Re: Help Newbie - SSIS run in SQL server agent job
- Previous by thread: Re: Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'ClGeClie'
- Next by thread: import subset of text files in a directory
- Index(es):
Relevant Pages
|
