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


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
.

Relevant Pages

  • Re: Need help with copy database
    ... Because when coping to the production server I don't have access to moving ... called Copy Database, it should be usable. ... the number of errors reaches the number specified in MaximumErrorCount. ...
    (microsoft.public.sqlserver.dts)
  • URGENT: Application_Start - doesnt fire
    ... Server 2003 production server. ... In IIS Manager I have ensured that there is a unique Application name in the ... database. ... requested that I get a general HTTP exception - but on the second request ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Front page 2002 and Access DB works in Stage not in Prod
    ... FrontPage Resources, WebCircle, MS KB Quick Links, etc. ... Publish to our Production server (still Intranet so no proxy ... Open the actual database and no new information is in the database. ... > connection rebuild from Options screen. ...
    (microsoft.public.frontpage.client)
  • Profiler...sorry for the multi-post
    ... I have a trace file that I captured from my production server that I want to replay on my dev box. ... The database on dev is a restore of the production backup, but the DB_ID of the two is different, which I believe is causing these errors: ... No matching connection to execute this on. ...
    (microsoft.public.sqlserver.programming)
  • Re: Development environment and deployment
    ... At any way, in Business Intelligence Development Studio, right click ... You set them to appropriate information for Production Server. ... Click OK button to close the database Property Pages Dialog box. ...
    (microsoft.public.sqlserver.olap)