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" (917406)



The information in this article applies to:

  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Workgroup
  • 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 "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.

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.
  1. 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.
  2. Open the Sqlwb.exe.manifest file in Notepad or in another text editor.
  3. 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>
  4. Save the changes, and then exit Notepad or the text editor.
  5. Try to modify the SQL Server 2000 DTS package in SQL Server 2005.

Method 2

  1. 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.
  2. Open the DTS package in SQL Server Enterprise Manager, and then save the DTS package. To do this, follow these steps:
    1. Open SQL Server Enterprise Manager, and then connect to an instance of SQL Server 2000.
    2. 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.
    3. Locate the .dts file, click Open, select the package, and then click OK to open the DTS package in SQL Server 2000 DTS Designer.
    4. In SQL Server 2000 DTS Designer, click Save on the Package menu.
  3. Modify the SQL Server 2000 DTS package in SQL Server 2005.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" 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: Search for "SQL Server 2000 DTS Designer components."

REFERENCES

For more information about how to how to install client tools only when you install SQL Server 2000, visit the following MSDN Web site:

Modification Type:MajorLast Reviewed:4/20/2006
Keywords:kbExpertiseAdvanced kbtshoot kbprb KB917406 kbAudDeveloper kbAudITPRO