August 12, 2010 at 9:25 am
Hi All,
I ran the Upgrade Advisor on a server running SQL 2005 Enterprise Edition (wanting to upgrade to SQL 2008) and the for the SQL Server component the Advisor gave me 2 errors
1. SQL Server 2000 Meta Data Services packages not supported.
2. SQL Server 2000 DTS Designer components are required to edit DTS packages
The issue here is, that SQL 2000 was not installed on this server before. So there are no DTS packages. There is 1 Maintainence Task created (Backup) but this is saved under the MSDB database. When you login to SSIS you see the package under MSDB.
Any assistance is appreciated.
Thanks
Denesh Naidoo
August 12, 2010 at 3:43 pm
Do you have any databases that show compatibility levels of "80"? It may have done this check if it sees any at that level.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
August 13, 2010 at 12:22 am
Hi,
None of the dbs are in compatibility 80.
August 13, 2010 at 7:17 am
Something I noticed reading this: Using the DTS Package Migration Wizard
Does it show up under "Other Upgrade Issues"? The upgrade advisor cannot analyze some DTS things in the msdb database, so it might just be it found the backward compatible tools for SQL 2000 that get installed with 2005 SSMS.
Not knowing for sure, but if you know you don't have any DTS packages I would not worry about it.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply