Posted by Russ Rose on 03/05/07 05:56

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@waikato.ac.nz> wrote in message
news:1173065296.527747.58960@c51g2000cwc.googlegroups.com...
> 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]