reporting-servicesvisual-studio-2017azure-devopssql-server-data-toolstfvc

VS2017 15.4.2 - project file is not bound to source control after SSRS project upgrades


Today I updated Visual Studio 2017 to 15.4.2 and found that the projects that come with SQL Server Data Tools (SSDT) 15.4.0 preview were no longer available, a common occurrence following an update. I repaired the SSDT install to find the projects did not come back, I then re-installed it and the projects were now available.

Now when I open an existing solution that contains 19 reporting services projects I was prompted that they needed to be upgraded, I haven't had this prompt since using the preview on first release. I went ahead and upgrading all the projects, added a new report to a project and submitted changes to my TFVC repository in Team Services.

Now whenever I open this solution I am prompted with this for every project:

The project file is not bound to source control, but the solution contains source control binding information for it. Do you want to open the project using source control binding information from the solution or open it as unbound and fix the solution file?

If I use the solution binding this works until I close the solution and then I'm prompted again for the same thing. If I choose to remove the solution bindings and bind them again via File > Source Control > Advanced > Change Source Control once the solution is saved and closed I get the same prompt.

I've downloaded a specific version from my repository prior to the project upgrades and I'm just getting prompted to upgrading them which breaks the source control again.

As it stands my solution is unusable, is there a way to fix my solution/project files manually as the suggested fixes I've seen so far are not working.


Solution

  • I have managed to resolve this for now by doing the following

    1. Uninstall Visual Studio 2017 15.4.2 and SQL Server Data Tools (SSDT) 15.4.0 preview
    2. Install Visual Studio 2017 15.3.5
    3. Install SQL Server Data Tools (SSDT) 15.4.0 preview
    4. Remove Microsoft Reporting Services Projects 1.17 in Extensions and Updates
    5. Install Microsoft Reporting Services Projects 1.18 in Extensions and Updates

    I've found that updating Visual Studio 2017 to 15.4.2 after this none of the business intelligence projects are available. Microsoft Reporting Services Projects 1.18 is listed in Extensions and Updates but I had to reinstall this to be able to open the projects.