RE: Insert Error: Column name or number of supplied values does not ma

From: "Gopalan" <Gopalan@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Wed, 3 Aug 2005 23:25:42 -0700

The simple way is select the option to write the log file on dts only.

"Dutchieboy" wrote:

>
> I get the above error when I run a very simple DTS package to copy a
> database from my production server to my development server. This has always
> worked in the past. Unfortunately, it does not tell me which table is causing
> the error (and 200 tables, so I don't want to run it for each one). Using the
> database import/export wizard to do the copying gives the same problem.
>
> I ran dbcc checkdb, but that reports no problems and did not help. Any
> suggestions?
>
> Thanks
> --
> Jan
.

Follow-Ups:
- RE: Insert Error: Column name or number of supplied values does no
  - From: Dutchieboy

References:
- Insert Error: Column name or number of supplied values does not ma
  - From: Dutchieboy

Prev by Date: Re: DTS issue....please help!!
Next by Date: Re: Select Statement
Previous by thread: Re: Insert Error: Column name or number of supplied values does no
Next by thread: RE: Insert Error: Column name or number of supplied values does no
Index(es):
- Date
- Thread

Relevant Pages

OLAP cubes computation will NOT terminate
... We have the case on a PRODUCTION Server where from time to time, ... the OLAP cube recomputation invoked inside a DTS ... may not terminate after 10 hours. ...
(microsoft.public.sqlserver.olap)
Re: Move DTS Package
... The easiest way is to do a 'save as ' in a structured storage file and then ... on the production server read this file into the DTS designer by right click ... >I have a dts pagkage on a development server. ...
(microsoft.public.sqlserver.dts)