I've recently migrated all databases to SQL Server 2005. I couldn't
figure out how to create an SSIS package in the time I had, so I just
stuck with the DTS packages. They all worked fine during testing, but
once we renamed the server we had problems. The DTS packages still
work, but whenever I click into the Copy SQL Server Object and try to
Select Objects (on the Copy tab) I get this error:

Microsoft SQL-DMO
Error 21776: General Error

I click OK and get the error again and again for a total of 12 times
(regardless of which database I'm connecting to in the packages, so
it's not related to the number of objects in the database). Then the
Select Objects screen appears and it's business as usual.

Has anyone else come across this problem and found a solution? I've
renamed the server using sp_dropserver and sp_addserver and select
@@servername returns the correct value



John Hunter

In the past I would script out the DB and then copy the data, but just
restoring on 2005 from the 2000 backup files has worked flawlessly for this
version upgrade on dozens of my production databases.

I have never had much success using DTS for object transfers.


<jshunter (AT) waikato (DOT) ac.nz> wrote