Post reply

VS 2015 deploy to SQL 2019

  • March 15, 2021 at 11:30 am

    #3857921

    Hi

    We just had a SQL upgrade (SQL 2019) in our dev server and our SSIS solutions no longer work. We are using Visual Studio 2015 and the solutions run fine locally from within VS.

    Is there a compatibility issue between VS2015 and SQL2019? I can't find much on the web.

    In VS, the solution properties, TargetServerVersion drop down only has up to SQL Server 2017.

    Thanks

    • This topic was modified 3 years, 10 months ago by  spin.

  • March 15, 2021 at 2:55 pm

    #3858019

    You need to target the correct version. So I suggest you install VS2019 and also make sure you get the latest SSIS through the Extensions Menu (after you upgrade to 2019) - Extension Manager.

    The screen shot shows the proj props target version dropdown in 2019.

    • This reply was modified 3 years, 10 months ago by  TangoVictor.

    Attachments:
    You must be logged in to view attached files.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply