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 5 and 3 and type the answer here:
  • Post
  • Wes,

    Let us know your email address.

  • Sent to shahul (dot) reshma (at) gmail (dot) com

  • please send the DLL to this email

    PrinceBlackHeart@Gmail.com

    Urgent please...

    Many thanks

  • please send the DLL to this email

    PrinceBlackHeart@Gmail.com

    Urgent please...

    Many thanks

  • Sent to PrinceBlackHeart at Gmail dot com

  • please send me the stardds.dll to pdenning@expedia.com

  • I followed the instructions but still no luck with any of the steps.

    Can you please send me the stardds.dll, my email is ipon6mt@gmail.com.

    Thanks,

    Michael

  • Sent to ipon6mt at gmail dot com and pdenning at expedia dot com

  • Hello,

    Could you please send me the stardds.dll with File Version 2000.80.2151.0, Size 172KB,   Date Modified 3/29/2006 5:08AM

    in order for me to edit DTS packages.

    Mail to :  wiselym@jrmc.org

    Thanks

    Mike

  • Hi I have problem for the jump boxes. Jump box is for application user to create or edit the SSIS.

    I used all above mentioned solutions but still getting the same 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".

    Any suggestion will be appreciated.

    Thanks

  • Hi Roopa Dilip .

    try installing SQL2005 SP3 DTS Designeer from the link

    www.microsoft.com/.../details.aspx

    Install the SQLServer2005_DTS.msi

  • Hello, could you please send the 2005.90.4035.0 version of stardds.DLL to davelhombardo (at) gmail (dot) com. I am running Windows 7 and currently have version 2000.80.2151.0 of stardds.DLL and have tried all of the steps outlined in your article (except for changing the stardds.DLL) and have still not been able to get DTS viewing/editing working in SQL Server 2008 MMC. My reference for why I need the 2005.90.4035.0 version of the stardds.DLL: thesqldude.com/.../designer Thanks,

  • Hi All,

     I`ve an issue only with text annotations. I cannot edit or delete them

     Server 2008 R2

     All other related stuff works ok

     Any suggestions?

     eduardo.goicovich@gmail.com

  • Is there any thing similar for SQL server 2008 R2 ?

  • Thanks a ton, step 4 (running the repair tool) did the trick for me.  I didn't see that anywhere else but here. Nice work.

Page 3 of 7 (103 items) 12345»