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

This error has nothing to do with corruption, but just indicating that the
table structures are different between your prod and dev SQL Servers.

Can you run the DTS package interactively and see on which table you are
failing?

Or can you add a log file for the package and capture the output?

You could also use Profiler to see where your package is failing.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/



"Dutchieboy" <jang-donotspammme@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:B4B2EB55-091D-4088-A5C9-C6EE908BAE6E@xxxxxxxxxxxxxxxx
>
> 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: Insert Error: Column name or number of supplied values does no
    ... I did use a log file which gets the following: ... As to running interactively, if you don't mean using the database wizard, I ... > table structures are different between your prod and dev SQL Servers. ... > Can you run the DTS package interactively and see on which table you are ...
    (microsoft.public.sqlserver.dts)
  • Changing the owner of a DTS Package
    ... Is it possible to change the owner of a DTS package? ... The reason I ask is that I am trying to tighten security on our SQL Servers ... Only the Package Owner Or a member Of sysadmin can change a DTS package. ... What would be useful would be to change the owner to the developers Live DB ...
    (microsoft.public.sqlserver.dts)
Loading