Nowadays, SQL Server 2000 DTS is deprecated. If you try to open a DTS using SQL Server Management Studio 2005 or 2008 you will get the following 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.
