The 'ProviderPackage' package did not load correctly

Question

I installed Visual Studio 2012 and at a later date Update 2. After installing Update 2, when I load any project, I get the following error:

---------------------------
Microsoft Visual Studio
---------------------------
The 'ProviderPackage' package did not load correctly.

The problem may have been caused by a configuration change or by the installation of another extension. You can get more information by examining the file 'C:\Users\username\AppData\Roaming\Microsoft\VisualStudio\11.0\ActivityLog.xml'.

Continue to show this error message?
---------------------------
Yes No
---------------------------

After locating the ActivityLog.xml, I see the following set of errors:

<entry>
    <record>300</record>
    <time>2013/04/23 18:32:54.002</time>
    <type>Information</type>
    <source>VisualStudio</source>
    <description>Begin package load [ProviderPackage]</description>
    <guid>{5F2E5E42-4192-4D79-A0D8-1D881E808829}</guid>
</entry>
<entry>
    <record>301</record>
    <time>2013/04/23 18:32:54.012</time>
    <type>Error</type>
    <source>VisualStudio</source>
    <description>SetSite failed for package [ProviderPackage]</description>
    <guid>{5F2E5E42-4192-4D79-A0D8-1D881E808829}</guid>
    <hr>80131522</hr>
    <errorinfo>Method 'GetHostedIntellisenseTypes' in type 'Microsoft.VisualStudio.Progression.DTEWrapperCached' from assembly 'Microsoft.VisualStudio.GraphProviderPackage, Version=11.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' does not have an implementation.</errorinfo>
</entry>
<entry>
    <record>302</record>
    <time>2013/04/23 18:32:54.012</time>
    <type>Error</type>
    <source>VisualStudio</source>
    <description>End package load [ProviderPackage]</description>
    <guid>{5F2E5E42-4192-4D79-A0D8-1D881E808829}</guid>
    <hr>80131522</hr>
    <errorinfo>Method 'GetHostedIntellisenseTypes' in type 'Microsoft.VisualStudio.Progression.DTEWrapperCached' from assembly 'Microsoft.VisualStudio.GraphProviderPackage, Version=11.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' does not have an implementation.</errorinfo>

Google searches do not reveal an exact match on my issue. I've tried searching the packages on the install ISO and cannot locate a package that needs to be repaired...

F:\packages>dir /s *provider*
 Volume in drive F is VS2012_ULT_MSDN_ENU
 Volume Serial Number is 4A21-C8BD

 Directory of F:\packages\SSDT

   07/26/2012  11:30 AM           780,288 DbSqlPackageProvider.msi
               1 File(s)        780,288 bytes

     Total Files Listed:
               1 File(s)        780,288 bytes
               0 Dir(s)               0 bytes free

Any other ideas?

Answer 1

• Close Visual Studio.
• Open a Developer Command Prompt for Visual Studio 2012 (as administrator).
• Type devenv /setup.
• Restart Visual Studio.

Possible duplicate of Visual Studio 2012 error: Package 'Visual C++ package' failed to load

See Visual C++ package: failed to load?????

Answer 2

This is Aaron's (Aaron Reed) answer from above, just copied as an answer instead of part of the question:

Fixed it... Fixed it... Fixed it...

1. Opened Programs and Features (run: appwiz.cpl)
2. Sorted list of installed apps by: Install Date
3. Filtered list by adding "SQL" to the upper right search filter
4. List item

I installed VS2012 on 4/1/13, so I went through each listed SQL item in the list, and right click --> Repair

From there I ran VS2012 and opened the target Solution file without issue.

My list:

• Microsoft SQL Server 2012 Data-Tier App Framework
• Microsoft SQL Server Data Tools - enu (11.1.20627.00)
• Microsoft SQL Server 2012 Management Objects (x64)
• Microsoft System CLR Types for SQL Server 2012 (x64)
• Microsoft System CLR Types for SQL Server 2012
• Microsoft SQL Server 2012 Management Objects
• Microsoft SQL Server 2012 Transact-SQL Compiler Service
• Microsoft SQL Server 2012 Command Line Utilities
• Microsoft SQL Server Data Tools Build Utilities - enu (11.1.206...
• Microsoft SQL Server Compact 4.0 SP1 x64 ENU
• Microsoft SQL Server 2012 T-SQL Language Service
• Microsoft SQL Server 2012 Native Client
• Microsoft SQL Server 2012 Data-Tier App Framework
• Microsoft SQL Server 2012 Express LocalDB
• Microsoft SQL Server 2012 Transact-SQL SpriptDom

Answer 3

This worked for me -

In order to fix the issue one needs to clear the Visual Studio cache under:

%LOCALAPPDATA%\Microsoft\VisualStudio\11.0\ComponentModelCache

Thanks go to blog post SetSite failed for package [Microsoft.VisualStudio.Editor.Implementation.EditorPackage].

Answer 4

Usually this can be fixed by clearing the Visual Studio cache under:

Visual Studio 2012: %LOCALAPPDATA%\Microsoft\VisualStudio\11.0\ComponentModelCache

Visual Studio 2013: %LOCALAPPDATA%\Microsoft\VisualStudio\12.0\ComponentModelCache

Answer 5

I fixed this by uninstalling or removing:

Microsoft SQL Server Data Tools - enu (14.0.50325.0)

I hope this helps :)