Error 04018: The “SqlBuildTask” task failed unexpectedly

16 Jan

I intend to use a SQL Server Database Project in my Visual Studio Solution to manage the database. This is a very nice feature and you should try it. Nevertheless, after upgrading the SQL Server Management Studio 2012 to SP1 I was not able to build the SQL Server Database Project anymore. I always got the following error message:

Error 2 04018: The “SqlBuildTask” task failed unexpectedly. System.MissingMethodException: Method not found: ‘Void Microsoft.Data.Tools.Schema.SchemaModel.DataSchemaModel.Serialize(System.IO.TextWriter, System.Collections.Generic.IEnumerable`1)’. at Microsoft.Data.Tools.Schema.Sql.Build.SqlTaskHost.SerializeModel(String outputFile) at Microsoft.Data.Tools.Schema. Tasks.Sql.SqlBuildTask.ExecuteSerializeModelStep() 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.d__20.MoveNext() C:\Program Files (x86)\MSBuild\Microsoft\VisualStudio\v11.0\SSDT\ Microsoft.Data.Tools.Schema.SqlTasks.targets

After a few attempts, I found the solution. I just downloaded and installed the new version of (SQL Server Data Tools)[] and the exception has disappeared.


Posted by on January 16, 2013 in SQL, Visual Studio


Tags: ,

5 responses to “Error 04018: The “SqlBuildTask” task failed unexpectedly

  1. Chris Staley (@cstaley)

    March 1, 2013 at 21:04

    Thanks for taking the time to type this up. It would have taken forever for me to figure this out.

  2. ryanvdwal

    October 16, 2013 at 13:08

    Thank you too for this post. Lifesaver! ;D

  3. stevejansen

    November 25, 2014 at 03:09

    Worked for me! Thank you! For others’ benefit, I’m on Microsoft Visual Studio Express 2013 for Web Version 12.0.31101.00 Update 4. It’s working now with SQL Server Data Tools Version 12.0.41025.0 installed.

  4. Graeme Allwood

    May 15, 2015 at 06:12

    Nice first answer in google…. and it was the answer I was looking for 🙂


Leave a Reply

Please log in using one of these methods to post your comment: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: