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 1 and type the answer here:
  • Post
  • Been through all the steps up to 5.  Still get "The DTS host failed to load or save the package properly."  Could you send the stardds.dll file please?  

    jimwebster@cigilife.com

    Thanks

  • Completed all steps up to 5, but still getting error. Please would you send the stardds.dll file please?

    tfox@spmsd.com

    Thanks

  • Sent to tfox@spmsd.com and jimwebster@cigilife.com

  • Can you send the stardds.dll to dan.royer at gmail.com?

  • Hi,

     Please send the stardds.dll to chjoelee@hotmail.com.

     Thanks

  • Hi.

    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.

    BR

    Alexander

    alexanderschott@mail.dk

  • Can you send the stardds.dll to hin0217@gmail.com ?

  • Sent to

    dan.royer at gmail dot com

    chjoelee at hotmail dot com

    hin0217 at gmail dot com

    alexanderschott at mail dot dk

  • Can u email the stardds.dll to me at celiawon@yahoo.com.sg

  • Sent to celiawon at yahoo dot com dot sg

  • Hello,

    please send us the stardds.dll, we couldn`t find the dll in the www..., to

    info@muenster.creditreform.de

    thanks a lot

  • Sent to info at muenster dot creditreform dot de

  • Hi.

    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 ID :shahul.reshma@gmail.com

    Thanks

    Reshma

  • Dears

    at what email should we contact you?

    I need this dll urgently

    thanks

  • Wes,

    Let us know your email address.

Page 2 of 7 (100 items) 12345»