I'm upgrading sql 2000 to sql 2005 before I upgrade GP 9 to GP 10. I ran the
sql server 2005 upgrade advisor and the advisor reports that 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.



I opened Enterprise Manager, Click Data Transformation Services, Click Meta
Data and receive the following error: An error occurred while trying to
access the database information. The msdb database could not be opened.



Please advise how I can get past this error to proceed with the upgrade.

I have no DTS packages.

Hi Julian,
If you can directly access your msdb database and view the underlying
tables in your Enterprise Manager, I recommend that you just ignore that
error message and went through the update on your SQL Server since you do
not have any DTS package. Before you upgrade your SQL Server 2000 to 2005,
please backup your databases first.

SSIS is totally different from DTS, so it is atually a pure new component
compared to DTS. The upgrade process actually only tries to update DTS
packages to SSIS packages, but this is not guaranteed to be successful.
After the upgrade, you may still have some work to do so that the upgraded
SSIS package can successfully run. For more information, please refer to:
Upgrading or Migrating Data Transformation Services
http://technet.microsoft.com/en-us/l...6(SQL.90).aspx
How to: Migrate Data Transformation Services Packages to Integration
Services
http://technet.microsoft.com/en-us/l...6(SQL.90).aspx
Upgrading SQL Server Components
http://technet.microsoft.com/en-us/l...0(SQL.90).aspx

Best regards,
Charles Wang

i am running into same situation. upgrade process is not advancing and
throwing a message stating "upgrade advisor returned -1". I don't see any
DTS packages that could cause the situation.