MS SQL Server - SQL 2005 Upgrade Advisor error

Author

SQL 2005 Upgrade Advisor error

Johnny

2006-10-31, 7:12 pm

I ran SQL 2005 upgrade advisor (version 9.00.2047.00 as at June 2006) for a
very simple SQL instance without any DTS package, took the default options to
analyse the components "SQL Server" & "Data Transformation Services".

It came up with DTS error and required to fix before the actual upgrade.
Are they misleading errors and can be ignored ?

PreUpgrade - SQL Server 2000 Meta Data Services packages are not supported -
Existing Meta Data Services packages should be moved to SQL Server storage
(in the msdb database) or to structured storage files before you upgrade. SQL
Server 2005 does not install support for SQL Server 2000 Meta Data Services;
therefore the Package Migration Wizard will be unable to access Meta Data
Services packages after upgrade in the absence of the SQL Server 2000 Client
Tools

PreUpgrade - SQL Server 2000 DTS Designer components are required to edit
DTS packages - 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

Regards,
Johnny

John Bell

2006-10-31, 7:12 pm

Hi Johnny

Has there ever been any DTS packages on this system?

I can't see that this would stop an upgrade, but you may want to try the
uninstall and re-attach rather than upgrading in-situ, as an alternative.
Make sure that you have all eventualities covered by your upgrade plan
regardless of the method you use to upgrade!

John

"Johnny" wrote:

> I ran SQL 2005 upgrade advisor (version 9.00.2047.00 as at June 2006) for a
> very simple SQL instance without any DTS package, took the default options to
> analyse the components "SQL Server" & "Data Transformation Services".
>
> It came up with DTS error and required to fix before the actual upgrade.
> Are they misleading errors and can be ignored ?
>
> PreUpgrade - SQL Server 2000 Meta Data Services packages are not supported -
> Existing Meta Data Services packages should be moved to SQL Server storage
> (in the msdb database) or to structured storage files before you upgrade. SQL
> Server 2005 does not install support for SQL Server 2000 Meta Data Services;
> therefore the Package Migration Wizard will be unable to access Meta Data
> Services packages after upgrade in the absence of the SQL Server 2000 Client
> Tools
>
> PreUpgrade - SQL Server 2000 DTS Designer components are required to edit
> DTS packages - 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
>
> Regards,
> Johnny

Johnny

2006-10-31, 7:13 pm

Hi John,

As I remembered, there is no DTS packages ever on that SQL 2000 instance.
I'll try to do the upgrade in-place and see how it goes.

I properly use side-by-side upgrade for production system rather than
in-place.

Thanks.
Johnny
"John Bell" wrote:
[color=darkred]
> Hi Johnny
>
> Has there ever been any DTS packages on this system?
>
> I can't see that this would stop an upgrade, but you may want to try the
> uninstall and re-attach rather than upgrading in-situ, as an alternative.
> Make sure that you have all eventualities covered by your upgrade plan
> regardless of the method you use to upgrade!
>
> John
>
>
>
> "Johnny" wrote:
>

Sponsored Links