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

  • Article

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

Comments

  • Anonymous
    June 01, 2009
    PingBack from http://paidsurveyshub.info/story.php?id=69929

  • Anonymous
    September 01, 2010
    Very nice article, good and clean :)

  • Anonymous
    January 04, 2011
    The comment has been removed

  • Anonymous
    January 05, 2011
    Nicole, Send me the error  ,"set path" output and version of stardds.dll and comctl32.dll karthick  

  • Anonymous
    February 15, 2011
    I have the same problem as Nicole. Nothing seems to work for SQL Server 2008 R2 or 2005. I've tried on multiple servers and instances of SQL Server 2005 and 2008 R2. I installed SQLServer2005_BC.msi and SQLServer2005_DTS.msi a long time ago. When that didn't work I tried KB 917406 method 1 and 2. When that failed, I found this blog and tried resolution part 2 (both methods). Still get the error at the beginning of this blog. I just sent you additional details.

  • Anonymous
    March 23, 2011
    Thanks dude. Excellent article. It really works for me. Hands off to SQLserverDon.

  • Anonymous
    August 07, 2011
    Great post! Thanks

  • Anonymous
    July 23, 2012
    It worked for me thanks

  • Anonymous
    May 08, 2015
    It worked for me also, thank you for the write up. It took me around 3 months to find this article and fix it on my work computer.