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"
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
Method 3
Uninstall Backward Compatibility components
Uninstall DTS Designer Components
Reistall it again
No comments: