If the "SQL Server 2000 DTS Designer Components" download is already installed, there might be a problem with the compatibility of icons persisted in this DTS package. See the following KB article for more details: http://support.microsoft.com/kb/917406 (Microsoft.SqlServer.DtsObjectExplorerUI)------------------------------

Opening a DTS Package works on all of our other operating systems including a Windows 2008 R2 64-bit server, Windows 2008 64-bit, Windows XP. I have tried all that I have found suggested online including: - Installed SQLServer2005_BC_x64.msi (Backward Compatability). - Installed SQLServer2005_DTS.msi. - In the PATH Environment Variable have moved 'C:\Program Files (x86)\Microsoft SQL Server\80\Tools\Binn' in front of all other SQL Server folders. - Have edited sqlwb.exe.manifest as suggested in http://support.microsoft.com/kb/917406. - Have rebooted.

Actually looks like i now have this working for SSMS 2005 (not SSMS 2008 R2), which may be good enough for now. Below is what I think got it to work. I say I think because it is not completely isolated from other attempts I was trying. Prior to doing this installed SQL 2008 r2 SP1 and made sure SQL 2005 SP4 plus Hotfix was applied the the SQL Tools on this Windows 7 vm machine (meant to only be a client to manage SQL Servers).

Thanks UconnDBA. This worked for me. I just wanted to post up my confirmation that this works.

The only difference in my environment is that I have both SQL 2005 (9.00.5000) and SQL 2008 R2 (10.50.2500) on my XP 32-bit workstation. The 2005 Backward Compatibility would not install, probably because the 2008 R2 BC was already installed. Also, I edited sqlwb.exe.manifest as suggested in KB 917406 as step 1. I did everything else in the order you listed.