Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Cannot open SSIS package (.dtproj file) after reinstalling Visual Studio 2015

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.

like image 543
hellogoodnight Avatar asked May 16 '16 15:05

hellogoodnight


People also ask

How do I open SSIS project in Visual Studio 2015?

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.

How do I run SSIS package as administrator in Visual Studio?

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.

How do I open an existing package in SSIS?

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.

How do I open an integration service package?

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.


1 Answers

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.

like image 85
Ricardo C Avatar answered Oct 08 '22 12:10

Ricardo C