You may experience problems when you try to run a SQL Server 2000 DTS package after you upgrade all the instances of SQL Server 2000 to SQL Server 2005 (919131)

RESOLUTION

To resolve this problem, use one of the following methods to repair the SQL Server 2005 Backward Compatibility Components.

If you use method 1, method 2, or method 3, we strongly recommend that you install the latest SQL Server 2005 service pack when you are finished. If you cannot do this, we recommend that you reinstall the SQL Server service pack that you were running before you repaired the SQL Server 2005 Backward Compatibility Components.

Additionally, if the problem involves SQL Server Agent, you must restart the SQL Server Agent service after you use one of these methods.

Method 1

Repair the SQL Server 2005 Backward Compatibility Components by using Add or Remove Programs in Control Panel. To do this, follow these steps:

1. In Control Panel, open Add or Remove Programs.
2. In the Currently installed programs list, click Microsoft SQL Server 2005 Backward compatibility.
3. Click Change.
4. In the Microsoft SQL Server 2005 Backward Compatibility Setup Wizard, click Next.
5. On the Program Maintenance page, click Repair, and then click Next.
6. To repair the SQL Server 2005 Backward Compatibility Components, click Install.

Method 2

Repair the SQL Server 2005 Backward Compatibility Components by running the redistribution file on the SQL Server 2005 setup media in repair mode. To do this, follow these steps:

1. On the SQL Server 2005 setup media, locate the Servers\Setup folder, and then double-click the SQLServer2005_BC.msi file.
2. In the Microsoft SQL Server 2005 Backward Compatibility Setup Wizard, click Next.
3. On the Program Maintenance page, click Repair, and then click Next.
4. To repair the SQL Server 2005 Backward Compatibility Components, click Install.

Method 3

Repair the SQL Server 2005 Backward Compatibility Components by running a command for unattended installation. To do this, follow these steps:

1. Obtain the product code of the installed SQL Server 2005 Backward Compatibility Components. To do this, follow these steps:
   1. Start Registry Editor.
   2. Locate the following registry subkey:

      HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall

   3. Press CTRL+F.
   4. In the Find what box, type Microsoft SQL Server 2005 Backward compatibility, and then click Find Next.
   5. Locate the parent registry subkey of the registry entry that is found. The product code is the name of this registry subkey. For example, the product code may be ABB9B19D-3D5A-4162-87B2-242C49E63D14.
      
      The product code is also the value of the UninstallString registry entry in this registry subkey.
2. Obtain the full path of the SQLServer2005_BC.msi file.
   
   Note For SQL Server 2005 32-bit installations on the 32-bit subsystem (WOW64) of a 64-bit server, use the SqlServer2005_BC_x64.msi file that is located on the original setup media.
3. At a command prompt, run one of the following commands:
   • If you want the status to be displayed during setup, run the following command:

     msiexec /qb /fomus "ProductCode" | "FullPath\SQLServer2005_BC.msi" /lv "LogFile"

   • If you do not want the status to be displayed during setup, run the following command:

     msiexec /qn /fomus "ProductCode" | "FullPath\SQLServer2005_BC.msi" /lv "LogFile"

   Notes
   • ProductCode is a placeholder for the product code of the installed SQL Server 2005 Backward Compatibility Components. The product code is different for each release, for each language, and for each installation of the SQL Server 2005 Backward Compatibility Components.
   • FullPath is a placeholder for the full path of the SQLServer2005_BC.msi file.
   • LogFile is a placeholder for the path of the log file. You can omit the /lv switch if you do not need a log file.

Method 4

Warning Serious problems might occur if you modify the registry incorrectly by using Registry Editor or by using another method. These problems might require that you reinstall your operating system. Microsoft cannot guarantee that these problems can be solved. Modify the registry at your own risk.

Repair the SQL Server 2005 Backward Compatibility Components by manually updating the registry and the system path. To do this, follow these steps:

1. Create a .reg file that contains the following text.

   Windows Registry Editor Version 5.00
   
   [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\80\Tools\ClientSetup]
   "SQLPath"="C:\\Program Files\\Microsoft SQL Server\\80\\Tools"

2. To update the registry, double-click the .reg file that you created in step 1.
3. In the PATH system environment variable, add the following path.

   C:\Program Files\Microsoft SQL Server\80\Tools\Binn

Note In steps 1 and 3, you may have to update the path to reflect the actual location of the 80\Tools folder for the installation.