Comments
7 comments
-
I have the same issue - it broke vs2017 and vs2015. I uninstalled SQLPropt, and my build went back to normal. Now I have to dig out SQLPrompt 8 and install that. -
Xyzzy,
You correctly isolated the problem to SQL Prompt.
If I go to [Tools] [Extensions and Updates...] [Installed] SQL Prompt and <Disable> it, my builds work. Toggle it back to <Enable> and they fail.
I have a support ticket open on this already. -
Same here, 'Fix' by disabling SQL Prompt works. First release of SQL Prompt 9 worked
-
Hi All,
I've just reproduced this here as well. It worked before I updated to SSDT 17.4 (using VS2015, SSMS 17.4, SQL Prompt 9.0.3.3299; annoyingly I didn't record the SSDT version...). After updating to SSDT 17.4 I get the error you are seeing at the top. I've let the developers know and will update when I have further information!
For the time being, here is a link to 9.0.2 since the SSDT builds work with it.
Kind regards,
Alex -
Hi all,
The developers have fixed the issue in SQL Prompt v9.0.4.3408 (download here). I have confirmed it works for me in my replication here, but please do let us know that it works for you all also!
Kind regards,
Alex -
This has fixed this issues I was having in VS2015.
Thanks -
The update fixed my problem.
Thank you for the quick workaround and fix!
Add comment
Please sign in to leave a comment.
Then I installed SQL Toolbelt (Backup, Compare, Data Compare, Data Generator, Doc, Prompt, Search, Test, SSMS Integration Pack) and I now get this error when I build.
C:\Program Files (x86)\Microsoft Visual Studio\2017\Professional\MSBuild\Microsoft\VisualStudio\v15.0\SSDT\Microsoft.Data.Tools.Schema.SqlTasks.targets(559,5): Error: MSB4018: The "SqlBuildTask" task failed unexpectedly.
System.MissingMethodException: Method not found: 'Void Microsoft.Data.Tools.Schema.Sql.Deployment.SqlCmdFileVerifier..ctor(Microsoft.SqlServer.TransactSql.ScriptDom.TSqlParser, System.Collections.Generic.IDictionary`2<System.String,System.String>, Boolean)'.
at Microsoft.Data.Tools.Schema.Tasks.Sql.SqlBuildTask.ExecutePrePostScriptsValidationStep()
at Microsoft.Data.Tools.Schema.Tasks.Sql.SqlBuildTask.ExecuteStep(Func`1 step)
at Microsoft.Data.Tools.Schema.Tasks.Sql.SqlBuildTask.Execute()
at Microsoft.Build.BackEnd.TaskExecutionHost.Microsoft.Build.BackEnd.ITaskExecutionHost.Execute()
at Microsoft.Build.BackEnd.TaskBuilder.<ExecuteInstantiatedTask>d__26.MoveNext()
Based on a recommendation from another post I went to [Tools] [Extensions & Updates...] [Updates] and found an update to Visual Studio 15.5.2 and installed it in hopes it would fix any missing files, but the problem still exists.
Any suggestions?