Karthick PK 's Blog

Karthick PK's technical blog covering topics such as SQLServer troubleshooting, technologies and security.

Unable to open SQL2000 DTS packages in SQLserver2008 SSMS/BIDS 2008

Unable to open SQL2000 DTS packages in SQLserver2008 SSMS/BIDS 2008

Rate This
  • Comments 8

Problem
=======
When we open a SQL2000 DTS package in SQL2008 SSMS/BIDS It fails with below
error.

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)

 

Resolution
========
1.Install SQL Server 2000 DTS Designer Components, Microsoft SQL Server 2005 Backward Compatibility Components From Below Link
http://www.microsoft.com/downloads/details.aspx?FamilyID=536fd7d5-013f-49bc-9fc7-77dede4bb075&displaylang=en

And

2. In the Environment variable's Path Move "C:\Program Files (x86)\Microsoft SQL
Server\80\Tools\Binn\" Before SQL2008 Paths.

(or)

The other workaround without changing Path Environment variable is as following

To make the DTS designer work under SSMS, 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 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\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

You will be able to edit the SQL2000 Package from SSMS2008

 

Regards

Karthick PK

Comments
  • PingBack from http://paidsurveyshub.info/story.php?id=69929

  • Very nice article, good and clean :)

  • Hi,

    I try thousand times but still failed to load the SQL Server 2000 DTS Designer Components in either SSMS or BIDS.

    Anyone please help????

  • Nicole,

    Send me the error  ,"set path" output and version of stardds.dll and comctl32.dll

    karthick  

  • I have the same problem as Nicole. Nothing seems to work for SQL Server 2008 R2 or 2005. I've tried on multiple servers and instances of SQL Server 2005 and 2008 R2. I installed SQLServer2005_BC.msi and SQLServer2005_DTS.msi a long time ago. When that didn't work I tried KB 917406 method 1 and 2. When that failed, I found this blog and tried resolution part 2 (both methods). Still get the error at the beginning of this blog.

    I just sent you additional details.

  • Thanks dude.

    Excellent article. It really works for me.

    Hands off to SQLserverDon.

  • Great post! Thanks

  • It worked for me thanks

Page 1 of 1 (8 items)
Leave a Comment
  • Please add 1 and 8 and type the answer here:
  • Post