<div>
Those two warning messages are displayed every time you run Upgrade Advisor, regardless of whether they apply or not. &nbsp;If your not using DTS packages or Meta Data services, you should be able to upgrade without issues.<br />
<br />
Greg<br />
<br />
<br />

</div>


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




<div>
<div class="content wysiwyg-content">
When running the sql server 2005 upgrade advisor there are two thing I need to fix before the upgrade. &nbsp;I get the following messages:<br />
<br />
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, &quot;SQL Server 2000 DTS Designer Components&quot;, before or after you upgrade or uninstall SQL Server 2000.<br />
<br />
SQL Server 2000 Meta Data Services packages are not supported.<br />
<br />
What is it I need to do to resolve this error so I can initiate the upgrade. &nbsp;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. &nbsp;Please advise.
</div>
</div>


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.

Upgrading from sql 2000 to sql 2005

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.