DTS 2000 Designer Components

After installing the DTS 2000 designer components from the feature packI get the following error message when trying to open a package:

-

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)

The thing is that I have installed them!! so what's going on here, is there a registry key I need to remove or something?, I've uninstalled and re-installed them, rebooted the server numerous times but still no joy, SQL Server just tells me that they're not installed, as you can imagine this is a real pain as I cannot do anything with my legacy packages on the 2005 server.

I cannot just migrate the packages from my 2000 server as they are in daily use on a production server. Is there an option to migrate/copy packages but leave the source packages untouched?

Help!

Yay, I seem to have stumbled across a solution for this:-

1. Uninstall SQL Server 2005 Backward Compatibilty

2. Uninstall SQL Server 2000 DTS Designer Components

3. Re-install SQL Server 2005 Backward Compatibilty

4. Re-install SQL Server 2000 DTS Designer Components

5. On the SQL Server 2000, open te DTS package and save it to the 2005 Server ( it will be placed in the <server name>\Management\Legacy\Data Transformation Services folder)

6. Edit the package on the 2005 server, NB. if you make any changes and save the package, the designer will take it upon itself to kindly auto-arrange your package so the package you had taken time to lay out in a nice readable format now resembles a bowl of spaghetti.

I found that moving the 2000 DTS packages in any other way than in step 5 resulted in the designer throwing up all sort of errors, although it did still work until you actually tried to save it. In my opinion, this is far too flaky and I am very hesitant to upgrade to SQL 2005 and leave my DTS packages in the hands of this designer.

|||I am trying to to the same thing, where do I find the download "SQL Server DTS Designer Components"? Second question, did you get it to work?|||

The DTS designer components are part of the SQL Server 2005 feature pack, just do a search for it on the microsoft website.

I found that the designer components work ok for some of my 2000 packages but not for others. I don't know why it behaves like this and there is no pattern to it, all I know is that it is a pain in the backside.

hope this helps

|||

Feature Pack for Microsoft SQL Server 2005 - November 2005 http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en

Which includes -

Microsoft SQL Server 2000 DTS Designer Components http://download.microsoft.com/download/4/4/D/44DBDE61-B385-4FC2-A67D-48053B8F9FAD/SQLServer2005_DTS.msi

|||Thank you this solved my problem.