Error Message: Retrieving the COM class factory for component with CLSID {...} failed due to the following error: 80004005 (Microsoft.SqlServer.ManagedDTS)
Action:
After installation on 64bit Windows 7 or Windows Server 2008 R2 system, I'm no longer able to open a package in Visual Studio.
Error Message:
'Retrieving the COM class factory for component with CLSID {...} failed due to the following error: 80004005 (Microsoft.SqlServer.ManagedDTS)'
Solution:
The issue is now automatically resolved in 1.4 SR-3.
2. Microsoft has issued a fix. You can download from KB982110.
Windows 7 and or Windows Server 2008 R2 backward compatiblity is broken. The issue can be fixed manually by following these steps:
1. Open regedit and go to the following registry key for SQL 2005:
[HKEY_CLASSES_ROOT\AppID\{A72E164E-B74C-44DA-9027-D3CE2E9BA282}]
and for SQL 2008:
[HKEY_CLASSES_ROOT\AppID\{6A3A708F-D5F0-4265-936A-A3241C57E736}]
2. If DtsLibrary registry value starts with: C:\Program Files\... this is incorrect. Change the value to start with C:\Program Files (x86)\...
3. Restart your Visual Studio and try again to open a package.