Dave's Technophorical Times

A blog about Microsoft's Technologies!
SharePoint :: MVC :: ASP.NET :: IIS :: SQL Server :: Visual Studio :: MS Access

When you’re trying to open your SSIS or SSRS solution, you will get a message that the migration has failed or ‘The application which this project type is based on was not found.

From https://www.jonashendrickx.com/2017/06/26/cannot-open-ssrsssis-projects-vs2017/ 

Method 1

  1. Open ‘Microsoft Visual Studio 2017‘.
  2. In the menu bar, expand ‘Tools‘, then choose ‘Extensions & Updates‘. to install an extension.
  3. Search for ‘Microsoft Reporting Services Projects‘, and install this extension.
  4. To complete the installation, shut down all windows and instances of Microsoft Visual Studio 2017. Then the installer will start.
  5. Try to open your solution or projects (*.rptproj) again.

Method 2

  1. Close all windows and instances of ‘Microsoft Visual Studio 2017‘.
  2. Download ‘Microsoft Reporting Services Projects‘ from the Visual Studio marketplace.
  3. Open your solution or project.


7

The issue is, only adding nugget would not suffice. You need to install slowcheetah from visual studio marketplace. Following are the steps:

  1. Install SlowCheetah from Tools > Extensions and Updates
  2. Restart VS, allowing for the VSIX installer to run
  3. Create new C# App (.NET Framework). (In my case, it started to work on existing app also.)
  4. Show ALL Files in Project and you will see the Transformations

You will then also see the Transformation files in the Project file as explained below.

Unload the project and then Edit the project. Find the ItemGroup element that contains your newly created config file and add the <DependentUpon>Web.config</DependentUpon> element there, like so:



To "Dynamically" change the path of a Reference in Visual Studio you first need to Unload the Project, then Edit the *proj file.

Go down to the References Section change the Hard Coded Path to $(Configuration). This will dynamically change the reference when the Configuration is changed.

    <Reference Include="Dafran.Exceptions, Version=1.0.0.0, Culture=neutral, PublicKeyToken=08f619978b79cd15, processorArchitecture=MSIL">

      <SpecificVersion>False</SpecificVersion>

      <HintPath>\\zero\Builds\Dafran.Security\$(Configuration)\Dafran.Exceptions.dll</HintPath>

    </Reference>



The Blogger

Dave Stuart I'm a Developer with a passion for coding. I enjoy the challengers that come with the job! SharePoint is one of my expert areas along with .NET Web Development with MVC and good old MS Access VBA coding. I Blog so that I can remember how I did that way back when; PLUS all this stuff is searchable! I constantly study and run my own business, Dafran Inc. I have passed 22 Microsoft Exams since 1998 when I first jumped on the treadmill of knowledge. I hope that you enjoy this Blog as much as I enjoy updating it. All the very best from Calgary, Alberta, Canada. contact me at linkedin @ dafran.ca

Calendar

<<  September 2019  >>
MoTuWeThFrSaSu
2627282930311
2345678
9101112131415
16171819202122
23242526272829
30123456

View posts in large calendar

Sign in