Freigeben über


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

https://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

 

https://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)

https://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: 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 removed

  • Anonymous
    August 24, 2010
    Thanks Buddy... It solved my problem. :)

  • Anonymous
    October 22, 2010
    This solved the problem! Thanks so much

  • Anonymous
    November 10, 2010
    Brilliant, works a treat. Thank you so much

  • Anonymous
    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 Israel

  • Anonymous
    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 hours

  • Anonymous
    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 Thanks

  • Anonymous
    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 removed

  • Anonymous
    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 Thanks

  • Anonymous
    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 Thanks

  • Anonymous
    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 Thanks

  • Anonymous
    March 05, 2012
    Sent to tfox@spmsd.com and jimwebster@cigilife.com

  • Anonymous
    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.  Thanks

  • Anonymous
    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.dk

  • Anonymous
    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 dk

  • Anonymous
    May 02, 2012
    Can u email the stardds.dll to me at celiawon@yahoo.com.sg

  • Anonymous
    May 02, 2012
    Sent to celiawon at yahoo dot com dot sg

  • Anonymous
    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 lot

  • Anonymous
    May 02, 2012
    Sent to info at muenster dot creditreform dot de

  • Anonymous
    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 Reshma

  • Anonymous
    May 27, 2012
    Dears at what email should we contact you? I need this dll urgently thanks

  • Anonymous
    May 27, 2012
    Wes, Let us know your email address.

  • Anonymous
    May 27, 2012
    Sent to shahul (dot) reshma (at) gmail (dot) com

  • Anonymous
    May 30, 2012
    please send the DLL to this email PrinceBlackHeart@Gmail.com Urgent please... Many thanks

  • Anonymous
    May 30, 2012
    please send the DLL to this email PrinceBlackHeart@Gmail.com Urgent please... Many thanks

  • Anonymous
    May 30, 2012
    Sent to PrinceBlackHeart at Gmail dot com

  • Anonymous
    June 05, 2012
    please send me the stardds.dll to pdenning@expedia.com

  • Anonymous
    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, Michael

  • Anonymous
    June 14, 2012
    Sent to ipon6mt at gmail dot com and pdenning at expedia dot com

  • Anonymous
    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 Mike

  • Anonymous
    July 24, 2012
    The comment has been removed

  • Anonymous
    July 26, 2012
    Hi Roopa Dilip . try installing SQL2005 SP3 DTS Designeer from the link www.microsoft.com/.../details.aspx Install the SQLServer2005_DTS.msi

  • Anonymous
    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.com

  • Anonymous
    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 removed

  • Anonymous
    October 16, 2012
    Please send the file to me too phil@philwhite.com Thx

  • Anonymous
    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 thanks

  • Anonymous
    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) com

  • Anonymous
    November 16, 2012
    Please send me the comctl32.dll

  • Anonymous
    November 27, 2012
    Can you please email the dll to lpandbecky@yahoo.com?

  • Anonymous
    December 07, 2012
    The comment has been removed

  • Anonymous
    December 09, 2012
    I have not been able to find the correct version. Please email me that correct version Thank you JT trav21771@yahoo.com

  • Anonymous
    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.be

  • Anonymous
    December 20, 2012
    The comment has been removed

  • Anonymous
    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)com

  • Anonymous
    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)com

  • Anonymous
    February 13, 2013
    Hello, Please can you send me Stardds.dll to robert.cahyadi36@gmail.com

  • Anonymous
    February 19, 2013
    Can you sent it to edmundo.hernandezvela@molex.com best rgds

  • Anonymous
    March 05, 2013
    The comment has been removed

  • Anonymous
    March 05, 2013
    The comment has been removed

  • Anonymous
    March 11, 2013
    Please could you send me the DLL please ? amelia.raimundo@baloise.lu thanks

  • Anonymous
    May 01, 2013
    The comment has been removed

  • Anonymous
    May 11, 2013
    Hi, Please send the startdds.dll file to msrkarthik@gmail.com. Thanks

  • Anonymous
    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 Thanks

  • Anonymous
    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 thanks

  • Anonymous
    June 30, 2013
    Can you please send the stardds.ddl file to abhishek.kulkarni@rexnord.com

  • Anonymous
    July 07, 2013
    Can you please send the stardds.ddl file to august.uae@gmail.com

  • Anonymous
    August 02, 2013
    Can you send the correct StarDDS.ddl to chambedr@hotmail.com

  • Anonymous
    September 25, 2013
    The comment has been removed

  • Anonymous
    October 28, 2013
    Hi I tried but my dll is wrong can you send me the correct dll to me to? bengeltiger@hotmail.com thanks

  • Anonymous
    October 29, 2013
    I updated my path and that fixed my issue. Much appreciated.   Thank you.

  • Anonymous
    November 05, 2013
    The comment has been removed

  • Anonymous
    December 29, 2013
    thak you very much. this saved me ))

  • Anonymous
    February 24, 2014
    Can you send me Stardds.dll to cvijetin@gmail.com Thanks

  • Anonymous
    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/2005

  • Anonymous
    April 01, 2014
    forgot my e-mail dcorrea@metlife.com or dccorrea@live.com

  • Anonymous
    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, Ragitha

  • Anonymous
    April 09, 2014
    Can you send me Stardds.dll to raoijaz@gmail.com Thanks

  • Anonymous
    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.com

  • Anonymous
    April 24, 2014
    Can you email a copy to rsaduskysql@msn.com

  • Anonymous
    April 29, 2014
    hi kindly help me to get the  stardds.dll mentioned above same date and size and version

  • Anonymous
    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. Thks

  • Anonymous
    May 20, 2014
    can you send me stardds.dll to cletocs@gmail.com

  • Anonymous
    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 else

  • Anonymous
    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.com

  • Anonymous
    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


BUTTONS: OK

  • Anonymous
    July 31, 2014
    If you Could you please send me stardds.dll (stardds.dll.4035) to samueltech@live.com

  • Anonymous
    July 31, 2014
    sent to mohanee, samueltech, rmanop, cletocs, rsaduskysql, selvamurugan_mc, raoijaz, ragithamohan, dccorrea and cvijetin

  • Anonymous
    September 02, 2014
    Could you send me stardds.dll to mary_wang01@hotmail.com? thanks

  • Anonymous
    September 02, 2014
    Can you send me Stardds.dll to mary_wang01@gmail.com I tried all steps but this thanks

  • Anonymous
    September 03, 2014
    The comment has been removed

  • Anonymous
    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.be

  • Anonymous
    February 11, 2015
    Can you please send the DLL file to jtcox2@gmail.com. Thanks, Travis

  • Anonymous
    February 11, 2015
    Sent to jtcox2

  • Anonymous
    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.com

  • Anonymous
    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, Arijana

  • Anonymous
    April 19, 2015
    The comment has been removed

  • Anonymous
    April 19, 2015
    The comment has been removed

  • Anonymous
    April 23, 2015
    Can you please send the DLL file to c_crkannan@hotmail.com? Thanks. Regards, C.R.Kannan

  • Anonymous
    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 removed

  • Anonymous
    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 Paul

  • Anonymous
    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
    October 15, 2015
    could you please send me the stardds.dll to andre.nunes23@gmail.com

  • Anonymous
    April 18, 2016
    could you please send me a copy of the stardds.dll to diegocaracciolo@hotmail.com ? thanks

  • Anonymous
    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,Chris

  • Anonymous
    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.com

  • Anonymous
    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 removed

  • Anonymous
    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.