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<System.Type>)’. 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.<ExecuteInstantiatedTask>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.

About these ads
 
3 Comments

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

 

Tags: ,

3 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

     

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: