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)SSMS

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)SSMS

Ideally DTS Packages should be upgraded to SSIS packages as we move from sql 2000 to sql 2005/sql 2008. And one of the good articles which provides information on how to upgrade DTS packages to SSIS package is written by Jason Howell

http://blogs.msdn.com/psssql/archive/2009/02/19/how-to-copy-dts-2000-packages-between-servers-and-from-sql-2000-to-sql-2005-and-sql-2008.aspx

However due to compatibility reasons or some other reasons customer may still want to use DTS packages in Sql 2005/Sql 2008. It is possible to Design,modify and execute DTS packages with Legacy components of sql 2005/sql 2008 SSMS.

However we have seen that many of our Customers face errors such as listed below while opening a DTS package with SSMS in sql 2008.

TITLE: Object Explorer
------------------------------

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)

------------------------------
BUTTONS:

OK
------------------------------

OR

The DTS host failed to load or save the package properly

and in this blog I am going to mention some of the steps which we need to take so as to be able to open the DTS package successfully with sql 2008 SSMS.

There are 6 Steps that could help you resolve this issue. We suggest you test the package after completing every steps and need not follow the rest if its resolved

1) Install Sql Server 2000 DTS Designer Components using the following link

 

http://www.microsoft.com/downloads/details.aspx?FamilyID=536fd7d5-013f-49bc-9fc7-77dede4bb075&displaylang=en

2) Install Sql Server 2005 backward compatibility components available with Microsoft SQL Server 2008 Feature Pack using the following link depending (x86,x64 and IA64)

http://www.microsoft.com/downloads/details.aspx?FamilyId=C6C3E9EF-BA29-4A43-8D69-A2BED18FE73C&displaylang=en

3) We need to change the Environment Variable for the Server so that c:\Program files(x86)\Microsoft Sql Server\80\Tools\Binn is ahead and all the sql 2008 paths comes at the end and we can verify it by opening the command prompt and firing the command  “path”

C:\>path

PATH=C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\PROGRA~1\CA\SHARED~1\SCANEN~1;C:\Program Files\CA\eTrust Antivirus;C:\Program Files (x86)\Windows Imaging\;C:\Program Files (x86)\Microsoft SQL Server\80\Tools\Binn\;C:\Program Files\Microsoft SQL Server\100\DTS\Binn\;C:\Program Files\Microsoft SQL Server\100\Tools\binn\;C:\Program Files (x86)\Microsoft SQL Server\100\Tools\binn\;C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\;C:\Program Files (x86)\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\

OR

If you are not able to change the path Environment variable you can follow the following steps

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\%lang_id%\semsfc.dll
%Program Files%\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\%lang_id%\sqlgui.dll
%Program Files%\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\%lang_id%\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

To make the DTS designer work under BIDS for SQL Server 2008, 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 Visual Studio 9.0\Common7\IDE\semsfc.dll
%Program Files%\Microsoft Visual Studio 9.0\Common7\IDE\sqlgui.dll
%Program Files%\Microsoft Visual Studio 9.0\Common7\IDE\sqlsvc.dll
%Program Files%\Microsoft Visual Studio 9.0\Common7\IDE\Resources\%lang_id%\semsfc.rll
%Program Files%\Microsoft Visual Studio 9.0\Common7\IDE\Resources\%lang_id%\sqlgui.rll
%Program Files%\Microsoft Visual Studio 9.0\Common7\IDE\Resources\%lang_id%\sqlsvc.rll

Reference: http://msdn.microsoft.com/en-us/library/ms143755.aspx

4) Run the Repair for the sql server 2005 backward compatibility from Control Panel, Add/Remove Programs, Change
And now you should be able to open the DTS packages under SSMS.

The 5th step should be followed only if all the above step does not work.

5)  If the DTS packages are created from the servers which has comctl32.dll (located in C:\Wndows) older than 5.82.2900.2180 then replace the stardds.dll located in c:\Program Files\Microsoft Sql server\80\Tools\Binn (c:\Program Files(x86) Microsoft Sql server\80\Tools\Binn in case of x64 bit server) with the stardds.dll with File Version 2000.80.2151.0, Size 172KB,   Date Modified 3/29/2006 5:08AM.

If you need this dll please send an email to us

Note: This post should not be treated as the Microsoft’s Recommendation or Resolution to the problem, it is only a workaround which worked in our environment and so we would like to share it.

Parikshit Savjani
SE, Microsoft Sql Server.

Reviewed By

Levi Justus
Technical Lead, Microsoft Sql Server

And

Karthick Krishnamurthy
Technical Lead, Microsoft Sql Server

 

 

Leave a Comment
  • Please add 8 and 5 and type the answer here:
  • Post
  • I have tried all steps listed here with SQL 2008 R2.  The error I am currently getting is "The DTS host failed to load or save the package properly."  The DTS package was created on a Server 2000 machine.  Can you please send a copy of the dll to tjeffcoat (at) smartlinxsolutions (dot) com.  

  • I can't find the path %Program Files%\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Resources\1033\

    but I can see it as   C:\Program Files\Microsoft SQL Server\100\Tools\Binn\Resources\1033

    so can you please confirm if I am in the right track?

    I did all the above steps (as I cant find the 1033 as you listed so the RLLs are moved to Resources\1033 under Binn folder it self).

    Also please send the Stardds.dll to venuchaitu@gmail.com

  • Please send the file to me too

    phil@philwhite.com

    Thx

  • Hi, please send the Stardds.dll to tierney_ronan@hotmail.com. thanks!

  • Please send the file to jenyphur@cox.net

    thanks

  • Sent to

    jenyphur (at) cox (dot) net ;

    tierney_ronan (at) hotmail (dot) com ;

    phil (at) philwhite (dot) com ;

    venuchaitu (at) gmail (dot) com ;

    tjeffcoat (at) smartlinxsolutions (dot) com

  • Please send me the comctl32.dll

  • Can you please email the dll to lpandbecky@yahoo.com?

  • Please can you send me Stardds.dll to paul.jones@rlbuht.nhs.uk

  • I have not been able to find the correct version.

    Please email me that correct version

    Thank you

    JT

    trav21771@yahoo.com

  • Great one really :)nice explanation :)

  • Hello,

    Thank you for posting this workaround, but it still doesn't work for me.

    Could you send me the DLL "stardds.dll" with File Version 2000.80.2151.0 ?

    Thank you very much in advance!

    Best regards,

    Yves

    email: yves.porters@manpower.be

  • Sent to

    paul(dot)jones(at)rlbuht(dot)nhs(dot)uk

    lpandbecky(at)yahoo(dot)com

    trav21771(at)yahoo(dot)com

    yves(dot)porters(at)manpower(dot)be

  • Can someone please send me the stardds.dll" with File Version 2000.80.2151.0

    Many thanks, send to:

    alanfenwick(at)gmail(dot)com

  • This is Awesome!!! thanks for posting it :)

Page 4 of 7 (103 items) «23456»