Error Message: Retrieving the COM class factory for component with CLSID {...} failed due to the following error: 80004005 (Microsoft.SqlServer.ManagedDTS)

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.

    Book a Presales Call


    Are you new to COZYROC and evaluating our solutions? 
    Book a Presales Call with us now and get 5% off SSIS+.