I m trying to open 2000 DTS package in SSMS of SQL 2008 and get the below error: Any solution? 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------------------------------ thanks

You need to install the DTS Designer from the SQL Server Feature Pack, available here under Backwards Compatability: http://www.microsoft.com/downloads/details.aspx?FamilyID=c6c3e9ef-ba29-4a43-8d69-a2bed18fe73c&DisplayLang=en

Mahesh, Have you downloaded? This is link on Support for Data Transformation Services (DTS) in SQL Server 2008. Let us know if helpful.

Mahesh, Have you downloaded? This is link on Support for Data Transformation Services (DTS) in SQL Server 2008. Related page: http://www.sqlusa.com/bestpractices2008/administration/ssiswizardicon/

I already went thru the above andinstalled - SQLServer2005_BC & SQLServer2005_DTS softwares. The issue was with PATH environment variable setting. After changing the order in the path setting it got resolved. C:\Program Files\Microsoft SQL Server\80\Tools\Binn\; should appear before the C:\Program Files\Microsoft SQL Server\100\Tools\Binn\; Incase of 64 bit machine: C:\Program Files (x86)\Microsoft SQL Server\80\Tools\Binn\; Be sure to restart the SSMS after changing the PATH env variable. Thanks

Great! Can you mark this thread as "answered"?

I had same Issue but worked by below stepOnce you install DTS components ON the server where you are OPENING the packages FROM and not working DTS Components need to be installed on your workstation, not the server. Let us know if it solved the problem .Thanks Faiz Farazi MCDBA,MCSA

Where is the PATH environment vairable setting to change in the above answer? I have tried a bunch of suggestions and have not been able to resolve my problem opening a DTS in SQL 2005 or 2008.

Go to the Start menu, right-click on Computer, and choose Properties. Select Advanced System Settings (the Advanced tab), and there should be an Environment Variables button in the lower portion of the dialog. You can update the PATH variable here - make sure you change it under the System variables section.John Welch | www.mariner-usa.com | www.agilebi.com | ssisUnit.codeplex.com

This (changing the path) worked for me as well when I had the problem. Thanks very much for following up with your solution.

I already went thru the above and installed - SQLServer2005_BC & SQLServer2005_DTS softwares. The issue was with PATH environment variable setting. After changing the order in the path setting it got resolved. C:\Program Files\Microsoft SQL Server\80\Tools\Binn\; should appear before the C:\Program Files\Microsoft SQL Server\100\Tools\Binn\; Incase of 64 bit machine: C:\Program Files (x86)\Microsoft SQL Server\80\Tools\Binn\; Be sure to restart the SSMS after changing the PATH env variable. Thanks I used that way but every time the package strat load this error showed up Error HRESULT E_FAIL has been returned from a call to a COM component. (Microsoft Visual Studio) Note I am trying to open it from BIDS (Execute 2000 DTS task)Volcano "DATA is the Focus, Business is the Target"

I tried to resolve this issue using the suggestions above and it still didn't work. My environment is a 64 bit SQL 2008 environment.

Solved mine problem with editing SQL Server 2000 DTS with Management Studio 2005 on Win7 64! Thanks!

Mahesh, Thanks a BUNCH for your help, I was breaking my head over this and now it is solved! I am sane again. Thanks again:-)!!!

I got the same issue and I fixed it by replacing stardds.dll by the newer version.

I got the same error too! Where can I get the newer version of stardds.dll?

This solved my problem, thanks!!!

Thanks Mahesh, it solved my problem!

One thing to note on the environment variable. I had to set the variable as a System variable in Windows 7 (x64) and not as a User variable in system properties in order for the change to work. After setting the variable, I closed SSMS, reopened it and now I can open DTS packages.Kenny

Thanks Mahesh, I placed C:\Program Files (x86)\Microsoft SQL Server\80\Tools\Binn\; as my first entry in the path variable in x64 machine and it worked. Senthil.