SQL 2000 Upgrade advisor

Hi,

I plan to upgrade our SQL server to the 2005 version.
Running the upgrade advisor, I get the following message (see code below).

WehnI look at the table involved (DocumentIndex), it is empty (0 row). Those that indicates that I don't need to bother about this warning?

I also get a warning regarding the DTS package but I don't know if it can have a consequence after migrating.

thanks for your help on these issues.

Regards,

JBS

FTK
 
Database Server,"PreUpgrade","Increase database size to accommodate DOCID map","
Since the DOCID map in SQL Server 2005 is stored in the database, the size requirement on the database side has increased, but has reduced on the full-text catalog side. If a database contains a full-text index, you need to ensure that the file group associated with the base table has enough space to accommodate the additional space requirement for full-text indexes. Use the following formula to estimate the space required. 
(2*FTK+ 34bytes) * RC 
Where:
FTK = Full-Text Key Size 
RC = Row Count of the Table
,Database Name: XXXl_MSCRM","Table Name: DocumentIndex",
 
 
 
DTS:
 
SQL Server 2000 Data Transformation Services,"PreUpgrade","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 DTS Designer components are required to edit DTS packages.","Source Type: MSDB","Package Location: MOL240605-10","Instances: 1",
SQL Server 2000 Data Transformation Services,"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
SQL Server 2000 Data Transformation Services,"PostMigration","Replace functionality of complex Data Transformation task encapsulated in Execute DTS 2000 Package task.","The SQL Server 2005 Integration Services (SSIS) Package Migration Wizard does not migrate complex Data Transformation tasks in SQL Server 2000 Data Transformation Services (DTS) packages. The migrated package will contain encapsulated DTS functionality that must eventually be removed or redesigned.","Package Name: BPATL","Source Type: MSDB","Package Location: BPATL","Instances: 17",
SQL Server 2000 Data Transformation Services,"Advisory","Upgrade Advisor reports only on the most recent version of each DTS package.","Upgrade Advisor reports only on the most recent version of each DTS package. To report on multiple versions of a DTS package, use the SSIS Package Migration Wizard, which is included with SQL Server 2005.","Source Type: MSDB","Package Location: MOL240605-10","Instances: 1",
SQL Server 2000 Data Transformation Services,"Advisory","SQL Server 2000 Data Transformation Services is deprecated.","You must completely migrate existing SQL Server 2000 Data Transformation Services (DTS) packages to SQL Server 2005 Integration Services packages before support is withdrawn.","Source Type: MSDB","Package Location: MOL240605-10","Instances: 1",

Open in new window

jeebee75Asked:
Who is Participating?
 
reb73Connect With a Mentor Commented:
Table Name: DocumentIndex  - > Ignore the warning as you have no records in this table..

DTS package - > The warning indicates that the package hasn't been completely migrated to SSIS due to complex tasks.  Save the relevant DTS package as a structured storage file (*.dts) in SQL 2000 before proceeding with the upgrade and if the converted SSIS package has problems post upgrade, you can still run legacy DTS using sql_run.msi..
0
 
jeebee75Author Commented:
Thanks!
0
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.