Post reply

Fixing a project that was built under the wrong SQL Server version

  • August 19, 2020 at 1:42 pm

    #3781636

    Hey everyone, we are running SQL Server 2016. We are using VS SSDT 2017. Recently someone built the project deployment file with the properties set as SQL Server 2017 which is causing the Script tasks in the packages to fail due to validation errors. Would it be possible to open the solution in VS SSDT 2017, set the project properties to SQL Server 2016, and do a Rebuild to fix the validation errors?

     

     

     

  • August 19, 2020 at 3:27 pm

    #3781671

    Yes, open solution in VSTS2017.  Then go to Project.Properties.  In project Settings, you can change target platform.  You'll probably have to open the script tasks and rebuild them, but it might do it for you.  Then you're good to go

    For better, quicker answers, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

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

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