Upgrading from sql 2000 to sql 2005

When running the sql server 2005 upgrade advisor there are two thing I need to fix before the upgrade.  I get the following messages:

You can use SQL Server 2005 tools to edit your existing DTS packages. However, upgrading or uninstalling the last instance of SQL Server 2000 on a computer removes the components required to support this feature. You can retain or restore these components by installing the special Web download, "SQL Server 2000 DTS Designer Components", before or after you upgrade or uninstall SQL Server 2000.

SQL Server 2000 Meta Data Services packages are not supported.

What is it I need to do to resolve this error so I can initiate the upgrade.  I have no dts packages under local packages nor anything under meta data services however I get this message each time I try and upgrade our test sql server database.  Please advise.
v4seasonsAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

JestersGrindCommented:
Those two warning messages are displayed every time you run Upgrade Advisor, regardless of whether they apply or not.  If your not using DTS packages or Meta Data services, you should be able to upgrade without issues.

Greg


0
v4seasonsAuthor Commented:
Had to run the sqlrun_tools.msi on cd2 before running the sql upgrade on cd1.  No where are you instructed to do so but that seems to be the resolution.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.