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

• dndaughtery

  SSChampion

  Points: 11290

  More actions

  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?

   

   

   

• Mike01

  SSChampion

  Points: 11412

  More actions

  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/