Not able to open DTS package in sql server 2008 or sql server 2005.

When you get below DTS package error during accessing it then you should apply solution given in below section to fix this issue.

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)

Solution

Follow below step by step points to resolve this issue.

1-Install Sql Server 2000 DTS Designer Components
Download from here. This is the most current version as of the writing of this article.

2-Install Sql Server 2005 backward compatibility components
Download from here. This is the most current version as of the writing of this article.
This is available with the installation media for SQL Server 2008.

3-Verify your path environment variable. The SQL 2000 path should be placed in the string prior to the SQL 2008 variable. As a sample, this is what mine looks like.

%SystemRoot%system32;%SystemRoot%;%SystemRoot%System32Wbem;%SYSTEMROOT%System32WindowsPowerShellv1.0;C:Program FilesMicrosoft SQL Server80ToolsBinn;C:Program FilesMicrosoft SQL Server90Toolsbinn;C:Program FilesMicrosoft SQL Server90DTSBinn;C:Program FilesMicrosoft SQL Server90ToolsBinnVSShellCommon7IDE;C:Program FilesMicrosoft Visual Studio 8Common7IDEPrivateAssemblies;C:Program FilesMicrosoft SQL Server100DTSBinn;C:Program FilesMicrosoft SQL Server100ToolsBinnVSShellCommon7IDE;C:Program FilesMicrosoft SQL Server100ToolsBinn;C:Program FilesMicrosoft Visual Studio 9.0Common7IDEPrivateAssemblies

*You can access the environment variables in Windows 7 by: Right Click My Computer -> Properties -> Click Advanced System Settings -> Click Environment Variables -> Scroll to “Path” -> Click “Path” and then click Edit…

4-SSMS – Manually Copy Files.

DLL Files to copy
semsfc.dll, sqlgui.dll, sqlsvc.dll
Source
%Program Files%Microsoft SQL Server80ToolsBinn

Destination
%Program Files%Microsoft SQL Server100ToolsBinnVSShellCommon7IDE
%Program Files%Microsoft SQL Server100ToolsBinnVSShellCommon7IDE%lang_id%

RLL Files to copy
semsfc.rll, sqlgui.rll, sqlsvc.rll
Source
%Program Files%Microsoft SQL Server80ToolsBinnResources%lang_id%

Destination
%Program Files%Microsoft SQL Server100ToolsBinnVSShellCommon7IDEResources%lang_id%

5-BIDS Manually Copy Files
DLL Files to copy
semsfc.dll, sqlgui.dll, sqlsvc.dll

Source
%Program Files%Microsoft SQL Server80ToolsBinn

Destination
%Program Files%Microsoft Visual Studio 9.0Common7IDE

RLL Files to copy
semsfc.rll, sqlgui.rll, sqlsvc.rll
Source
%Program Files%Microsoft SQL Server80ToolsBinnResources%lang_id%

Destination
%Program Files%Microsoft Visual Studio 9.0Common7IDEResources%lang_id%

I had to create the Resources Subdirectory
%Program Files%Microsoft Visual Studio 9.0Common7IDE%lang_id%
The last step was not applicable in my case since the file version already matched
stardds.dll File version: 2000.80.2151.0

Follow me:

Manvendra Deo Singh

I am working as a Technical Architect in one of the top IT consulting firm. I have expertise on all versions of SQL Server since SQL Server 2000. I have lead multiple SQL Server projects like consolidation, upgrades, migrations, HA & DR. I love to share my knowledge. You can contact me on my social accounts for any consulting work.
Manvendra Deo Singh
Follow me:

You may also like...

1 Response

  1. Anonymous says:

    Thank you a lot you made my day

Leave a Reply

Your email address will not be published. Required fields are marked *