RSS

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)[http://msdn.microsoft.com/en-US/data/hh297027] and the exception has disappeared.

About these ads
 
4 Comments

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

 

Tags: ,

4 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.

     

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

 
Follow

Get every new post delivered to your Inbox.

%d bloggers like this: