Microsoft KB Archive/917406

= Error message when you try to modify a SQL Server 2000 DTS package in SQL Server 2005: &quot;The DTS host failed to load or save the package properly&quot; =

Article ID: 917406

Article Last Modified on 2/8/2007

-

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

-



Bug #: 345170 (SQLBUDT)



SYMPTOMS
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.

Note In this error message, the word &quot;connot&quot; is a misspelling for the word &quot;cannot.&quot;

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.



CAUSE
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.



WORKAROUND
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 :\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE folder.

Note  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.     Save the changes, and then exit Notepad or the text editor.</li> Try to modify the SQL Server 2000 DTS package in SQL Server 2005.</li></ol>

Method 2
<ol> 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.</li> Open the DTS package in SQL Server Enterprise Manager, and then save the DTS package. To do this, follow these steps: <ol style="list-style-type: lower-alpha;"> Open SQL Server Enterprise Manager, and then connect to an instance of SQL Server 2000.</li> 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.</li> Locate the .dts file, click Open, select the package, and then click OK to open the DTS package in SQL Server 2000 DTS Designer.</li> In SQL Server 2000 DTS Designer, click Save on the Package menu.</li></ol> </li> Modify the SQL Server 2000 DTS package in SQL Server 2005.</li></ol>

<div class="status_section">

STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.

<div class="moreinformation_section">

MORE INFORMATION
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:

http://msdn2.microsoft.com/en-us/sql/aa336314.aspx

Search for &quot;SQL Server 2000 DTS Designer components.&quot;

<div class="references_section">