Unable to open SQL2000 DTS packages in SQLserver2008 SSMS/BIDS 2008

Problem
=======
When we open a SQL2000 DTS package in SQL2008 SSMS/BIDS It fails with below
error.

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)

 

Resolution
========
1.Install SQL Server 2000 DTS Designer Components, Microsoft SQL Server 2005 Backward Compatibility Components From Below Link
https://www.microsoft.com/downloads/details.aspx?FamilyID=536fd7d5-013f-49bc-9fc7-77dede4bb075&displaylang=en

And

2. In the Environment variable's Path Move "C:\Program Files (x86)\Microsoft SQL
Server\80\Tools\Binn\" Before SQL2008 Paths.

(or)

The other workaround without changing Path Environment variable is as following

To make the DTS designer work under SSMS, user will need to manually copy the
following files
%Program Files%\Microsoft SQL Server\80\Tools\Binn\semsfc.dll
%Program Files%\Microsoft SQL Server\80\Tools\Binn\sqlgui.dll
%Program Files%\Microsoft SQL Server\80\Tools\Binn\sqlsvc.dll
%Program Files%\Microsoft SQL Server\80\Tools\Binn\Resources\%lang_id%\semsfc.rll

%Program Files%\Microsoft SQL Server\80\Tools\Binn\Resources\%lang_id%\sqlgui.rll

%Program Files%\Microsoft SQL Server\80\Tools\Binn\Resources\%lang_id%\sqlsvc.rll

To the following destination respectively
%Program Files%\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\semsfc.dll

%Program Files%\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\sqlgui.dll

%Program Files%\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\sqlsvc.dll

%Program Files%\Microsoft SQL
Server\100\Tools\Binn\VSShell\Common7\IDE\Resources\%lang_id%\semsfc.rll
%Program Files%\Microsoft SQL
Server\100\Tools\Binn\VSShell\Common7\IDE\Resources\%lang_id%\sqlgui.rll
%Program Files%\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Resources\%lang_id%\sqlsvc.rll

You will be able to edit the SQL2000 Package from SSMS2008

 

Regards

Karthick PK