Hello:

I have created a DTS package that copies the objects of 3
SQL 2000 databases to identical databases on another
server. The first 2 databases have no problem. The last
database throws up the following error after the step
runs for awhile:

Microsoft SQL-DMO (ODBC SQL State 21501)
[Microsoft][ODBC SQL Server Driver][SQL Server}
Insert Error: Column name or number of supplied values
does not match table definition.

These databases are mirror images of each other so I'm
clueless as to what the problem is.

Any comments or suggestions would be appreciated.

Brennan

Have you specified to drop existing objects as well or just move the data?

It suggests you are trying to insert data into a table that has more or less
columns than you are specifying i.e.

INSERT TABLE(col1,co2) VALUES(1,2,3)
OR
INSERT TABLE(col1,col2) VALUES(1)

You may be able to capture which particulr table this error pertains to by
using Profiler

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Brennan" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Thank you