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:If you click OK in the error message box, you receive the following error message: 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: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.

Back to the top

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.

Back to the top

To work around this problem, use one of the following methods.

Back to the top

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.

Back to the top

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: a. Open SQL Server Enterprise Manager, and then connect to an instance of SQL Server 2000. b. 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. c. Locate the .dts file, click Open, select the package, and then click OK to open the DTS package in SQL Server 2000 DTS Designer. d. In SQL Server 2000 DTS Designer, click Save on the Package menu.
3.	Modify the SQL Server 2000 DTS package in SQL Server 2005.

Back to the top

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Back to the top

If you receive the following error message, you have to download the SQL Server 2000 DTS Designer components: 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."

Back to the top

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

Back to the top