none
VS 2017 sql 2017 project incompatibel after running fine for days RRS feed

  • Question

  •  after running ok for days, after db server restart and BI server restart my project is incompatible 

    db: Microsoft SQL Server 2017 (RTM-CU14) (KB4484710) - 14.0.3076.1 (X64)   Mar 12 2019 19:29:19   Copyright (C) 2017 Microsoft Corporation  Developer Edition (64-bit) on Windows Server 2019 Standard 10.0 <X64> (Build 17763: ) (Hypervisor) 

    Unsupported
    This version of Visual Studio is unable to open the following projects. The project types may not be installed or this version of Visual Studio may not support them. 
    For more information on enabling these project types or otherwise migrating your assets, please see the details in the "Migration Report" displayed after clicking OK.
    - TrueDBproj, "D:\SSIS\TrueDBsol\TrueDBproj\TrueDBproj.dtproj"


    Non-functional changes required
    Visual Studio will automatically make non-functional changes to the following projects in order to enable them to open in Visual Studio 2015, Visual Studio 2013, Visual Studio 2012, and Visual Studio 2010 SP1. Project behavior will not be impacted.
    - TrueDBsol, "D:\SSIS\TrueDBsol\TrueDBsol.sln"

    Report:

    The application which this project type is based on was not found. Please try this link for further information:

    xxxx://go.microsoft.com/fwlink/?LinkId=660751&projecttype=159641D6-6404-4A2A-AE62-294DE0FE8301

    Thursday, May 23, 2019 1:32 PM

All replies

  • Hi William,

    Welcome to the MSDN forum.

    Have you tried to upgrade VS and modify any settings or install extensions before this issue happens?

    Please try to create a new SSIS project and check if this issue persists or not.

    According to the error message, we can follow this similar issue and try the following methods:

    1. Right click the project and “Reload project”
    2. Right click the project and choose “Resolve Errors”
    3. Go to Tools-Extensions and Updates and search for integration/analysis/reporting (delete as applicable) and [enable] or [disable and then re-enable], close and restart VS. When you restart, the projects will still show as incompatible, but right click and reload project seems to do the trick on each one.

    Best regards,

    Sara


    MSDN Community Support Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Friday, May 24, 2019 9:04 AM
    Moderator