You are here: Re: SQL Server 2005 DTS problem: "Error 21776: General Error" « MsSQL Server « IT news, forums, messages
Re: SQL Server 2005 DTS problem: "Error 21776: General Error"

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
>

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация