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
http://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 (9)

  1. Maurizio Amoroso says:

    Very nice article, good and clean 🙂

  2. Nicole says:

    Hi,

    I try thousand times but still failed to load the SQL Server 2000 DTS Designer Components in either SSMS or BIDS.

    Anyone please help????

  3. Nicole,

    Send me the error  ,"set path" output and version of stardds.dll and comctl32.dll

    karthick  

  4. Mike G says:

    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.

  5. Faheem Ahmad says:

    Thanks dude.

    Excellent article. It really works for me.

    Hands off to SQLserverDon.

  6. KEROBIN says:

    Great post! Thanks

  7. Gangs says:

    It worked for me thanks

  8. Cruz says:

    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.