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.
Who is Participating?
v4seasonsConnect With a Mentor Author 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.
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.


Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.