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

Hi Narayana , thanks for answering my post.

I did use a log file which gets the following:

Step Error Source: Microsoft SQL-DMO (ODBC SQLState: 21S01)
Step Error Description:[Microsoft][ODBC SQL Server Driver][SQL Server]Insert
Error: Column name or number of supplied values does not match table
definition.
Step Error code: 800400D5
Step Error Help File:SQLDMO80.hlp
Step Error Help Context ID:1131

So, that does not tell me where it is failing.

As for a mismatch between prod and dev, when I run the database import
wizard, I specify to drop the destination tables first - so how can there be
a mismatch?

As to running interactively, if you don't mean using the database wizard, I
don't know how to do that.


--
Jan


"Narayana Vyas Kondreddi" wrote:

> 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: Copy SQL Server Objects Fails for certain views
    ... Backup/Restore as transparent to the customer as our DTS package currently ... Our customers don't typically know a database from a monkey wrench. ... Copy objects just uses an alphabetical order. ...
    (microsoft.public.sqlserver.dts)
  • Re: Advice sought on use of DTS [Long]
    ... it may help to know that you can disable triggers temporarily do ... You may want to set up a sql job to copy over the remote database (the ... Can you programmatically tell a DTS package which databases to update? ...
    (microsoft.public.sqlserver.dts)
  • Re: Reading UDL files in DTS package- not working!!
    ... If you have changed the database in the UDL this is not reflected in the ... transform task, so if the Source on the task is shown as ... > re-open and re-save the DTS package, ...
    (microsoft.public.sqlserver.dts)
  • Re: Error 15022: The specified user name is already aliased.
    ... Issues When a Database Is Moved Between SQL Servers ... > permit role it shows that the user has a dbo role. ...
    (microsoft.public.sqlserver.security)
  • Re: Help with dtsrun and dts package.
    ... I dropped the tables from the database and that took care of the table ... The SQL server 2000 being used to create the dts package is on a different ... the MSDE master database but the message is that you cannot restore a SQL ... Can I create a dts package without using SQL 2000 Enterprise manager? ...
    (microsoft.public.sqlserver.odbc)