Posted by jshunter@waikato.ac.nz on 03/05/07 03:28

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

[Back to original message]