Designing \ Editing DTS packages in SSMS is one of the question I’m seeing in forums, this situation occurs when an upgrade happens from SQL 2000 to SQL 2005. When SQL server 2005 was released it doesn’t have a facility for editing \ designing DTS packages after upgrade. Even If you run upgrade advisor in that machine before upgrade you will be shown with a warning message as shown below.
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.