Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 917406 - Last Review: February 8, 2007 - Revision: 1.3
Error message when you try to modify a SQL Server 2000 DTS package in SQL Server 2005: "The DTS host failed to load or save the package properly"
Bug #: 345170 (SQLBUDT)
Consider the following scenario. You try to modify a
Microsoft SQL Server 2000 Data Transformation Services (DTS) package in SQL
Server 2005. SQL Server 2005 is installed on a Microsoft Windows Server
2003-based computer or on a Windows XP-based computer. In this scenario, you
receive the following error message:
Error Source :
Microsoft Data Transformation Services (DTS) Package
Error Description :
The DTS host failed to load or save the package properly.
If you click
OK in the error message box, you receive the following error
message:
The selected package connot be opened. The DTS
Designer has been closed.
In this error message, the word "connot" is a misspelling for the
word "cannot."
If you click
OK in this error message
box, you receive one of the following error messages:
Error message 1
Error HRESULT E_FAIL has been returned from
a call to a COM component
Error message 2
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)
This problem occurs
when all the following conditions are true:
- The SQL Server 2000 DTS package was last saved from an
instance of SQL Server 2000 that is running on a Windows 2000-based
computer.
- The SQL Server 2000 DTS package is stored in a structure
storage (.dts) file.
- The SQL Server 2000 DTS package is modified from an
instance of SQL Server 2005 that is running on a Windows Server 2003-based
computer or on a Windows XP-based computer.
The problem occurs because of a compatibility issue with how
icons are managed between DTS Designer in SQL Server 2000 and DTS Designer in
SQL Server 2005.
To work around this problem, use one of the following
methods.
Method 1
Warning The following information contains steps to modify a file. Make
sure that you back up the file before you modify it.
- Open the SQLInstall:\Program
Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE folder.
Note SQLInstall is a placeholder for the
drive where SQL Server 2005 is installed. - Open the Sqlwb.exe.manifest file in Notepad or in another
text editor.
- Remove the following lines of code from the
Sqlwb.exe.manifest file.
<dependency>
<dependentAssembly>
<assemblyIdentity type="win32" name="Microsoft.Windows.Common-Controls" version="6.0.0.0" processorArchitecture="x86" publicKeyToken="6595b64144ccf1df" language="*"></assemblyIdentity>
</dependentAssembly>
</dependency>
- Save the changes, and then exit Notepad or the text
editor.
- Try to modify the SQL Server 2000 DTS package in SQL Server
2005.
Method 2
- Install SQL Server Enterprise Manager on the computer that
is running SQL Server 2005. To do this, click Client Tools
Only when you install SQL Server 2000.
- Open the DTS package in SQL Server Enterprise Manager, and
then save the DTS package. To do this, follow these steps:
- Open SQL Server Enterprise Manager, and then connect to
an instance of SQL Server 2000.
- In SQL Server Enterprise Manager, expand the instance
of SQL Server 2000, right-click the SQL Server Data Transformation
Services folder, and then click Open
Package.
- Locate the .dts file, click Open,
select the package, and then click OK to open the DTS package
in SQL Server 2000 DTS Designer.
- In SQL Server 2000 DTS Designer, click
Save on the Package menu.
- Modify the SQL Server 2000 DTS package in SQL Server
2005.
Microsoft
has confirmed that this is a problem in the Microsoft products that are listed
in the "Applies to" section.
If you receive the following error message, you have to
download the SQL Server 2000 DTS Designer components:
SQL
Server 2000 DTS Designer components are required to edit DTS packages
The SQL Server 2000 DTS Designer components let you modify and maintain your
existing SQL Server 2000 DTS packages until they can be upgraded or re-created
in the SQL Server 2005 Integration Services package format. By using these
components, you do not have to reinstall the SQL Server 2000 tools.
To download the SQL Server 2000 DTS Designer components, visit the
following Microsoft Developer Network (MSDN) Web site:
Search for "SQL Server 2000 DTS Designer
components."
For more information about how to how to install client
tools only when you install SQL Server 2000, visit the following MSDN Web site:
APPLIES TO
- Microsoft SQL Server 2005 Standard Edition
- Microsoft SQL Server 2005 Workgroup Edition
- Microsoft SQL Server 2005 Developer Edition
- Microsoft SQL Server 2005 Enterprise Edition
| kbexpertiseadvanced kbtshoot kbprb KB917406 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate