SQL Server 2000 DTS Designer components are required to edit DTS packages - in SQL 2008
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
October 15th, 2008 4:05pm

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
Free Windows Admin Tool Kit Click here and download it now
October 15th, 2008 4:30pm

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

Mahesh, Have you downloaded? This is link on Support for Data Transformation Services (DTS) in SQL Server 2008. Let us know if helpful.
Free Windows Admin Tool Kit Click here and download it now
October 15th, 2008 4:34pm

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
October 16th, 2008 1:10pm

Great! Can you mark this thread as "answered"?
Free Windows Admin Tool Kit Click here and download it now
October 17th, 2008 4:39am

Great! Can you mark this thread as "answered"?
October 17th, 2008 4:39am

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
Free Windows Admin Tool Kit Click here and download it now
August 26th, 2009 9:59pm

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.
October 16th, 2009 10:50pm

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
Free Windows Admin Tool Kit Click here and download it now
October 17th, 2009 5:49pm

This (changing the path) worked for me as well when I had the problem. Thanks very much for following up with your solution.
December 24th, 2009 2:51am

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"
Free Windows Admin Tool Kit Click here and download it now
May 19th, 2010 5:54pm

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.
January 21st, 2011 2:22pm

Solved mine problem with editing SQL Server 2000 DTS with Management Studio 2005 on Win7 64! Thanks!
Free Windows Admin Tool Kit Click here and download it now
March 4th, 2011 7:24pm

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:-)!!!
April 28th, 2011 4:06pm

I got the same issue and I fixed it by replacing stardds.dll by the newer version.
Free Windows Admin Tool Kit Click here and download it now
June 22nd, 2011 11:16am

I got the same error too! Where can I get the newer version of stardds.dll?
July 2nd, 2011 10:00pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics