I have made an SSIS-package in Visual Studio 2015. A bit after, I had to reinstall VS because there was some trouble with an unrelated package. Now when I try to open the SSIS-package, I first get the following popup:
The 'ResourceManagerPackage' 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\xxx\Appdata\Roaming\Microsoft\VisualStudio\14.0\ActivityLog.xml'.
Restarting Visual Studio could help resolve this issue.
Continue to show this error message?
The popup pops up even when I just start VS.
After I click ok, the project does not load. In Solution Explorer, it says 'incompatible', and when I hover over it it says 'The application is not installed'.
How do I fix this?
edit I have run a repair of VS, and added the SSDT manually, no improvement. I have also opened the ActivityLog as suggested in the popup and searched for errors. I found this:
Could not load file or assembly 'Microsoft.AnalysisServices.Project, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
Could not load file or assembly 'Microsoft.ReportingServices.Designer, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
This might be it, but since I cannot even open the solution, I do not know how to fix it anyway.
In Visual Studio, click New > Project on the File menu. In the Installed Templates area of the New Project window, expand Business Intelligence, and click Integration Services. Select Integration Services Import Project Wizard from the project types list.
To do this, click Start, point to All Programs, point to SQL Server 2005 or SQL Server 2008, right-click the tool you are using and then click Run as administrator. This launches the application with elevated privileges of the Built In Administrator account and the package executes successfully.
Click the browse button (...), select the package to import, and then click Open. To import from the SSIS Package Store, select the SSIS Package Store option and specify the server. Click the browse button (...), select the package to import, and then click OK.
Go to Connect to Server and select the Server Type as Integration Services and give the Server Name then click connect. Go to Object Explorer on the left corner. You can see the Stored Package folder in Object Explorer. Expand the Stored Package folder, here you can see the SSIS interfaces.
The version of SQL Server is crucial here. The version of VS has been historically always one behind SQL Server e.g. SQL Server 2012 uses Visual Studio 2010 to edit SSIS packages.
See more at Download SQL Server Data Tools (SSDT)
As of 2022, this remains the case.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With