Problem

When trying to import a SQL Server 2000 DTS package to SQL Server 2008 R2 using SSMS, the following error occurs:

 

 

 

Managing DTS packages in SQL Server Management Studio requires the SQL Server 2000 Data Transformation Services (DTS) runtime. To install the DTS runtime, on your SQL Server 2008 R2 installation media, locate and run the Windows Installer package for SQL Server 2005 Backward Compatibility (SQLServer2005_BC*.msi). You can also download the DTS runtime from the SQL Server Feature Pack page on the Microsoft Download Center. (Microsoft.SqlServer.DtsObjectExplorerUI)

 

Solution

As suggested, the ?Microsoft SQL Server 2005 Backward compatibility? package must be installed. It can be found on this location:

http://www.microsoft.com/en-us/download/details.aspx?id=3522

 

...

 

After the installation of ?Microsoft SQL Server 2005 Backward compatibility? package the DTS package is imported successfully.

Now when we try to open the DTS package, the following error appears:

 

 

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)

 

To solve this error the ?Sql Server 2000 DTS Designer Components? package must be installed. It can be found on this location:

http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=11988

 

 

After the installation try to open again the DTS package in SSMS.   

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)

 

If the same error appears, copy the DLL and RLL files as described in below Microsoft link:

http://msdn.microsoft.com/en-us/library/ms143755.aspx

 

To ensure that the DTS designer can be used in SQL Server Management Studio

1.       Copy the files, SEMSFC.DLL, SQLGUI.DLL, and SQLSVC.DLL, from the %ProgramFiles%\Microsoft SQL Server\80\Tools\Binn folder to the %ProgramFiles%\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE folder.

2.       Copy the files, SEMSFC.RLL, SQLGUI.RLL, and SQLSVC.RLL, from the %ProgramFiles%\Microsoft SQL Server\80\Tools\Binn\Resources\%lang_id% folder to the %ProgramFiles%\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Resources\%lang_id% folder.

       For example, for U.S. English, the lang_id subfolder will be "1033".


To ensure that the DTS designer can be used in Business Intelligence Development Studio

1.       Copy the files, SEMSFC.DLL, SQLGUI.DLL, and SQLSVC.DLL, from the %ProgramFiles%\Microsoft SQL Server\80\Tools\Binn folder to the %ProgramFiles%\Microsoft Visual Studio 9.0\Common7\IDE folder.

2.       Copy the files, SEMSFC.RLL, SQLGUI.RLL, and SQLSVC.RLL, from the %ProgramFiles%\Microsoft SQL Server\80\Tools\Binn\Resources folder to the %ProgramFiles%\Microsoft Visual Studio 9.0\Common7\IDE\Resources\%lang_id% folder. For example, for U.S. English, the lang_id subfolder will be "1033".

 

 


7 comments

Comment from: Andrew [Visitor]
AndrewI tried all your steps but still getting "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)"

I'm using Win7 64bit. I have even copied the files to both Program Files(x86) and Program Files.

Any suggestions?
12/11/12 @ 22:44
Comment from: Rajesh S [Visitor]
Rajesh SIts working.
I have copied the .rll file to the specified location as per the error message.
Thanks a lot.
05/17/13 @ 06:40
Comment from: CEDA-2 [Visitor] Email
CEDA-2Cool!
06/28/13 @ 17:51
Comment from: noora [Visitor] Email
noorai am using window 8, and trying to connect to sql server 2000 using sql managament studio 2008 r2, i followed the step but i found that i cannot find this path "Microsoft SQL Server\80\Tools\Binn\Resources\1033" i can see only "Microsoft SQL Server\80\Tools\Binn\1033" which mean Resources folder was missing, i tried to created it manually, but it didnt worked
06/18/14 @ 12:12
Comment from: Tom [Visitor]
Tomnoora that's exactly the problem I've seen on my 64 bit Win7 machine. Did you ever resolve this on yours?
10/01/14 @ 01:51
Comment from: Jim [Visitor]
JimWorked like a charm, thanks for the post!
10/16/14 @ 21:51
Comment from: rahID [Visitor]
rahIDit's work finally, thanx a lot
10/06/16 @ 10:26

This post has 3 feedbacks awaiting moderation...

Leave a comment


Your email address will not be revealed on this site.
(Line breaks become <br />)
(For my next comment on this site)
(Allow users to contact me through a message form -- Your email will not be revealed!)