I'm running SQL Sever 2008ÃÂ Management Studio (Developer Edition) on an XP machine.
Unfortunately I still have to manage some DTS packages for SQL Server 2000, and wanted to do that without having to install SQL Server 2000 Enterprise Manager.
In SQL Server 2008 Object Explorer, going to Management->Legacy->Data Transformation Services, I could see all the DTS packages, however right-clicking and selecting open gave me this error:
SQL Server 2000 DTS Designer components are required to edit DTS packages. Install the special Web download, "SQL Server 2000 DTS Designer Components" to use this feature. (Microsoft.SqlServer.DtsObjectExplorerUI)
So these are the steps I followed that worked for me, and now I could open a design-time DTS package window from SSMS 2008:
1- Download and isntallÃÂ the latest Microsoft SQL Server 2005 Backward Compatibility Components (I know it says 2005 but that's what you need for SSMS 2008 as well.ÃÂ Also make sure you get the latest release, the one in this link is for December 2008)
2- Download and inst
View Complete Post