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
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
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)
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: https://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
Comments
Anonymous
May 11, 2010
The comment has been removedAnonymous
August 24, 2010
Thanks Buddy... It solved my problem. :)Anonymous
October 22, 2010
This solved the problem! Thanks so muchAnonymous
November 10, 2010
Brilliant, works a treat. Thank you so muchAnonymous
January 21, 2011
Thanks a lot for posting this! It resolved my problem too.Anonymous
February 07, 2011
Point 4 - Repair worked for me.. Thanks a lot :-)Anonymous
March 08, 2011
ah.. thanx for the hint with the PATH Environment Variable..Anonymous
May 07, 2011
Parikshit , thanx so much! I've been struggling with this !@#$%$##@! for DAYS! All the websites only refer to the DLLs and RLLs and to the 2 MSIs. What saved me was the stardds.dll! Have a beautiful life. Gil Gordon IsraelAnonymous
May 30, 2011
Thanks for this - re-ordering the path environment variable is the key that worked for me.Anonymous
July 11, 2011
Thank you so much for this!Anonymous
August 05, 2011
Thanks so much for the blog.It's solved my problem after 24 hoursAnonymous
August 24, 2011
Well, thank you very much! I've been stucked for almost a week on this. Thanks for the hint on step 4!Anonymous
September 07, 2011
Hi, can send me the link for download the dll? gjppy@hotmail.com ThanksAnonymous
October 06, 2011
An excellent thread that works, even today! Had been blissfully running SQL 8 R2 on my XP machine with old DTS. Then I got this new Win 7 64-bit machine and it seemed great, super-fast, more storage, SSD....until I tried to access my DTS packages. The instructions here to copy the files from 8.0 to 10.0 did the trick. Thanks!Anonymous
October 25, 2011
The comment has been removedAnonymous
November 22, 2011
Thanks, I saved my day !Anonymous
February 14, 2012
Hi, Can you send me the link for download the stardds.dll ? a.dangien@gmail.com ThanksAnonymous
February 28, 2012
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 ThanksAnonymous
March 05, 2012
Completed all steps up to 5, but still getting error. Please would you send the stardds.dll file please? tfox@spmsd.com ThanksAnonymous
March 05, 2012
Sent to tfox@spmsd.com and jimwebster@cigilife.comAnonymous
March 07, 2012
Can you send the stardds.dll to dan.royer at gmail.com?Anonymous
March 21, 2012
Hi, Please send the stardds.dll to chjoelee@hotmail.com. ThanksAnonymous
March 22, 2012
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.dkAnonymous
April 15, 2012
Can you send the stardds.dll to hin0217@gmail.com ?Anonymous
April 15, 2012
Sent to dan.royer at gmail dot com chjoelee at hotmail dot com hin0217 at gmail dot com alexanderschott at mail dot dkAnonymous
May 02, 2012
Can u email the stardds.dll to me at celiawon@yahoo.com.sgAnonymous
May 02, 2012
Sent to celiawon at yahoo dot com dot sgAnonymous
May 02, 2012
Hello, please send us the stardds.dll, we couldn`t find the dll in the www..., to info@muenster.creditreform.de thanks a lotAnonymous
May 02, 2012
Sent to info at muenster dot creditreform dot deAnonymous
May 23, 2012
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 ReshmaAnonymous
May 27, 2012
Dears at what email should we contact you? I need this dll urgently thanksAnonymous
May 27, 2012
Wes, Let us know your email address.Anonymous
May 27, 2012
Sent to shahul (dot) reshma (at) gmail (dot) comAnonymous
May 30, 2012
please send the DLL to this email PrinceBlackHeart@Gmail.com Urgent please... Many thanksAnonymous
May 30, 2012
please send the DLL to this email PrinceBlackHeart@Gmail.com Urgent please... Many thanksAnonymous
May 30, 2012
Sent to PrinceBlackHeart at Gmail dot comAnonymous
June 05, 2012
please send me the stardds.dll to pdenning@expedia.comAnonymous
June 14, 2012
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, MichaelAnonymous
June 14, 2012
Sent to ipon6mt at gmail dot com and pdenning at expedia dot comAnonymous
June 26, 2012
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 MikeAnonymous
July 24, 2012
The comment has been removedAnonymous
July 26, 2012
Hi Roopa Dilip . try installing SQL2005 SP3 DTS Designeer from the link www.microsoft.com/.../details.aspx Install the SQLServer2005_DTS.msiAnonymous
July 31, 2012
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,Anonymous
August 15, 2012
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.comAnonymous
October 02, 2012
Is there any thing similar for SQL server 2008 R2 ?Anonymous
October 10, 2012
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.Anonymous
October 11, 2012
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.Anonymous
October 12, 2012
The comment has been removedAnonymous
October 16, 2012
Please send the file to me too phil@philwhite.com ThxAnonymous
October 25, 2012
Hi, please send the Stardds.dll to tierney_ronan@hotmail.com. thanks!Anonymous
November 07, 2012
Please send the file to jenyphur@cox.net thanksAnonymous
November 07, 2012
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) comAnonymous
November 16, 2012
Please send me the comctl32.dllAnonymous
November 27, 2012
Can you please email the dll to lpandbecky@yahoo.com?Anonymous
December 07, 2012
The comment has been removedAnonymous
December 09, 2012
I have not been able to find the correct version. Please email me that correct version Thank you JT trav21771@yahoo.comAnonymous
December 14, 2012
Great one really :)nice explanation :)Anonymous
December 19, 2012
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.beAnonymous
December 20, 2012
The comment has been removedAnonymous
January 08, 2013
Can someone please send me the stardds.dll" with File Version 2000.80.2151.0 Many thanks, send to: alanfenwick(at)gmail(dot)comAnonymous
January 16, 2013
This is Awesome!!! thanks for posting it :)Anonymous
January 24, 2013
Great detailed post on the problem. Awesome!. Please send stardds.dll file to : mzphipps@hotmail.com Thanks.Anonymous
January 26, 2013
Sent to alanfenwick(at)gmail(dot)com mzphipps(at)hotmail(dot)comAnonymous
February 13, 2013
Hello, Please can you send me Stardds.dll to robert.cahyadi36@gmail.comAnonymous
February 19, 2013
Can you sent it to edmundo.hernandezvela@molex.com best rgdsAnonymous
March 05, 2013
The comment has been removedAnonymous
March 05, 2013
The comment has been removedAnonymous
March 11, 2013
Please could you send me the DLL please ? amelia.raimundo@baloise.lu thanksAnonymous
May 01, 2013
The comment has been removedAnonymous
May 11, 2013
Hi, Please send the startdds.dll file to msrkarthik@gmail.com. ThanksAnonymous
May 28, 2013
Hi, can send me the link for download the dll? with the stardds.dll with File Version 2000.80.2151.0, Size 172KB, Date Modified 3/29/2006 5:08AM. zdz_2006@sina.com ThanksAnonymous
June 28, 2013
Hi, I have tried all of the above on a new machine where I have installed windows 2008 server r2 and sql server 2008 r2..for some reasons, I am not able to get to open dts packages for edit. Can you pls send me link for the stardds.dll file thanksAnonymous
June 30, 2013
Can you please send the stardds.ddl file to abhishek.kulkarni@rexnord.comAnonymous
July 07, 2013
Can you please send the stardds.ddl file to august.uae@gmail.comAnonymous
August 02, 2013
Can you send the correct StarDDS.ddl to chambedr@hotmail.comAnonymous
September 25, 2013
The comment has been removedAnonymous
October 28, 2013
Hi I tried but my dll is wrong can you send me the correct dll to me to? bengeltiger@hotmail.com thanksAnonymous
October 29, 2013
I updated my path and that fixed my issue. Much appreciated. Thank you.Anonymous
November 05, 2013
The comment has been removedAnonymous
December 29, 2013
thak you very much. this saved me ))Anonymous
February 24, 2014
Can you send me Stardds.dll to cvijetin@gmail.com ThanksAnonymous
April 01, 2014
I have made the 4 steps and dont work, I create a new server, install sql server 2008 from zero also. the version of my stardds.dll details are: File Version 2000.80.2151 Product Versiopn 8.00.2151 Date modified 10/14/2005Anonymous
April 01, 2014
forgot my e-mail dcorrea@metlife.com or dccorrea@live.comAnonymous
April 08, 2014
Hi Parikshit, I am facing the exact issue. the only step left is replace stardds.dll. Could you please send stardds.dll with File Version 2000.80.2151.0, Size 172KB, Date Modified 3/29/2006 5:08AM to ragithamohan@hotmail.com Thanks, RagithaAnonymous
April 09, 2014
Can you send me Stardds.dll to raoijaz@gmail.com ThanksAnonymous
April 10, 2014
Worked great. Had to go to step 3, adjusting the PATH after installing the add-ons did it for me.Anonymous
April 12, 2014
Still I am having issue, pls send me the stardds.dll My mail id: selvamurugan_mca@yahoo.comAnonymous
April 24, 2014
Can you email a copy to rsaduskysql@msn.comAnonymous
April 29, 2014
hi kindly help me to get the stardds.dll mentioned above same date and size and versionAnonymous
May 19, 2014
Hello, I just follows the step In my case the folder "Resources" no existed: %Program Files%Microsoft Visual Studio 9.0Common7IDEResources%lang_id% (Don't Existe). I just create a new folder "Resources" copie the existen folder (1033) into the new "Resources" and that solved my problem. ThksAnonymous
May 20, 2014
can you send me stardds.dll to cletocs@gmail.comAnonymous
May 21, 2014
hi - I was struggling to get this to work on our servers until I realized that the SQL tools had been installed onto a drive D: so I copied the dllrll files into, for example: D:AppsMicrosoft SQL Server (x86)100ToolsBinnVSShellCommon7IDE just a hint in case it helps someone elseAnonymous
June 02, 2014
I do all step 1-4, but error is not resolve. So, I check stardds.dll is as follow: File version: 2000.80.2151.0 Size: 179 KB Date Modified: 10/14/2005 Could you send me stardds.dll to rmanop@hotmail.com? Thank you.Anonymous
July 17, 2014
Could you please send me stardds.dll to mohanee@hotmail.comAnonymous
July 30, 2014
Error persists... Windows 7 Enterprise 64X SP1 Microsoft SQL Server(2005) Management Studio 9.00.4035.00 Legacy sql server 2000 dts packages TITLE: Microsoft SQL Server Management Studio
Operation not supported on version 10.50. (Microsoft.SqlServer.SqlEnum) For help, click: go.microsoft.com/fwlink
BUTTONS: OK
Anonymous
July 31, 2014
If you Could you please send me stardds.dll (stardds.dll.4035) to samueltech@live.comAnonymous
July 31, 2014
sent to mohanee, samueltech, rmanop, cletocs, rsaduskysql, selvamurugan_mc, raoijaz, ragithamohan, dccorrea and cvijetinAnonymous
September 02, 2014
Could you send me stardds.dll to mary_wang01@hotmail.com? thanksAnonymous
September 02, 2014
Can you send me Stardds.dll to mary_wang01@gmail.com I tried all steps but this thanksAnonymous
September 03, 2014
The comment has been removedAnonymous
September 28, 2014
Can you send me Stardds.dll to bearchui@gmail.com ? Thanks a lot.Anonymous
October 06, 2014
can you pls send me stardds.dll to criddick73@gmail.com?Anonymous
October 17, 2014
Please send me the stardds.dll to jburgess@resultstechnology.com. Thank you very much.Anonymous
December 02, 2014
Hi, Is it necessary that we install SQLServer2005_DTS.msi and then SQLServer2005_BC.msi or it can be any order?Anonymous
January 18, 2015
I do all step 1-4, but error is not resolve. Could you send me stardds.dll to andy_fsd@hotmail.com? Thank you.Anonymous
February 04, 2015
could you please send me the stardds.dll to brecht.proesmans@live.beAnonymous
February 11, 2015
Can you please send the DLL file to jtcox2@gmail.com. Thanks, TravisAnonymous
February 11, 2015
Sent to jtcox2Anonymous
April 01, 2015
I tried all the steps above except dll change nothing seems to work. Only last option is left out Please provide the stardds.dll My mail id: sarthaks@outlook.comAnonymous
April 13, 2015
I have tried everything. I even tried to copy the dll from the old server but it didn't work. Can you please send the DLL file to orka2006@gmail.com? Thank you in advance for your assistance. Kind regards, ArijanaAnonymous
April 19, 2015
The comment has been removedAnonymous
April 19, 2015
The comment has been removedAnonymous
April 23, 2015
Can you please send the DLL file to c_crkannan@hotmail.com? Thanks. Regards, C.R.KannanAnonymous
May 06, 2015
Hello, I followed your steps, but i have a little detail, i can open DTS packages but i can't see them when i import them to my own server, do you have any suggestions ? Regards.Anonymous
May 06, 2015
Hi, i followed the instructions but at the end when i can't see my dts package, do you have any suggestion? Regards.Anonymous
May 09, 2015
The comment has been removedAnonymous
June 24, 2015
Can you send to STARDDS.DLL to drew.missy.p@gmail.com Thanks,Anonymous
September 28, 2015
Can you send me the dll file to p.garrad@btopenworld.com Thanks PaulAnonymous
October 09, 2015
Can you please send the stardds.dll file to lsholcomb@gmail.com. Thanks, Les- Anonymous
October 26, 2016
Please send me stardds.dll Thanks. - Anonymous
January 11, 2017
The comment has been removed
- Anonymous
Anonymous
October 15, 2015
could you please send me the stardds.dll to andre.nunes23@gmail.comAnonymous
April 18, 2016
could you please send me a copy of the stardds.dll to diegocaracciolo@hotmail.com ? thanksAnonymous
May 19, 2016
I followed the steps. I even have stardds.dll with the version and folder mentioned here. I can see DTS packages. But when I right click and open them, I get the error being discussed. BTW, I have SQL Server 2014 and SQL server 2008R2 installed and I am trying to access DTS packages on SQL Server 2000 from SQL server 2008R2. I am on Window 7, 64 bit machine. Any thoughts?Anonymous
May 23, 2016
please mail me the stardds.dll to vinaygs@gmail.com, with above changes it goes till i can see the packg versions and try open it it fails with same error.Anonymous
June 14, 2016
Please send the newer stardds.dll file to cjnigg@netins.netThanks,ChrisAnonymous
August 18, 2016
Can you please send the stardds.dll file to arosales (at) tbccorp (dot) com.Thanks,Anonymous
September 28, 2016
A bit late to this, but can you send the stardds.dll to def.python74(at)gmail.com?Anonymous
October 12, 2016
Hello,can you please send me the dll.My email is ccorream@outlook.comregards,Anonymous
October 19, 2016
Can you send the stardds.dll to madhudba85@gmail.comAnonymous
October 26, 2016
Please send me stardds.dllThanks.Anonymous
December 12, 2016
How to open dts package using SQL Server 2008R2 free edition. None of the links posted above is working.Anonymous
January 11, 2017
The comment has been removedAnonymous
April 05, 2017
I need the stardds.dll file. Can someone send it to me?Anonymous
April 18, 2017
Can you please rename stardds.dll file to stardds.txt and send to manlanc@gmail.com.