I get the error
Missing values for the following SqlCmd variables:Path1 Path2.
in a few Sql Projects in Visual Studio.
I tried googleling it but found nothing.
4 Answers
I hit this issue. I'd added some SQLCMD variables then deleted them. The SQLCMD variables no longer existed in the publish files or the .sqlproj file. I grepped all the files in the project and the variables didn't exist anywhere. I'd restarted Visual Studio. However I was still getting the Missing values for the following SqlCmd variables: error.
From the project directory I deleted the *.dbmdl and *.sqlproj.vspcc files. The project then published successfully.
Related