blocks|key|2943375|text|原来问题出在Visual+Studio+Update+3上。我卸载并重新安装了VS+2013，只更新到Update+2，然后重新安装了数据工具，现在它工作得很好。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2943376|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

It turns out the issue was with Visual Studio Update 3. I uninstalled and reinstalled VS 2013 to Update 2 only and reinstalled Data Tools and it works perfectly now.

blocks|key|2731167|text|您需要安装SQL+Server+Data+Tools的最新版本：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2731168|http://msdn.microsoft.com/en-US/data/hh297027|offset|length|2731169|确保重新启动VS，然后再次构建解决方案。这就解决了问题！|2731170|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|19|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@$D|Q|E|R|1|S]]|A|$]]|$1|F|3|G|5|6|7|T|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|U|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|C]]]]

You need to install the last version of SQL Server Data Tools:

<a href="http://msdn.microsoft.com/en-US/data/hh297027" rel="nofollow noreferrer">http://msdn.microsoft.com/en-US/data/hh297027</a>

Make sure to restart VS and then build the solution again. This solves the problem!

blocks|key|150749|text|在Visual+Studio2013+->+Tools+->扩展和更新中...->将->产品更新->+Microsoft+SQL+Server数据库更新至12.0.50318.0|type|unstyled|depth|inlineStyleRanges|entityRanges|data|150750|我从12.0.41012.0升级，这解决了我的问题。这与安装最新的SQL+Server数据工具的答案有关。|150751|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

In Visual Studio 2013 -> Tools -> Extensions and Updates... -> Updates -> Product Updates -> Microsoft SQL Server Update for database to 12.0.50318.0 

I was upgrading from 12.0.41012.0 and this resolved my issue. This relates to the answer to install the latest SQL Server Data Tools.

blocks|key|2731303|text|我正在使用Visual+Studio+Community+2013。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2731304|我也犯了同样的错误：|2731305|您可以通过更新SQL+Server工具来修复此问题：|2731306|Tools+-->+Extensions+and+Updates|code-block|syntax|javascript|2731307|​|2731308|📷|atomic|offset|length|2731309|2731310|然后，在“产品更新”下，您将看到一个更新SQL+Server更新的选项。|2731311|在安装了restart+Visual+Studio之后，单击Update。|2731312|2731313|2731314|2731315|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/d83326a1ff13c5948aec0d9e42de7911.png|imageAlt|1|https://ask.qcloudimg.com/http-save/yehe-900000/3573409e5875843590af2ac720fda917.png^0|0|0|0|0|0|0|1|0|0|0|0|0|0|0|1|1|0|0^^$0|@$1|2|3|4|5|6|7|1A|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1B|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|1C|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|1D|8|@]|9|@]|A|$I|J]]|$1|K|3|L|5|6|7|1E|8|@]|9|@]|A|$]]|$1|M|3|N|5|O|7|1F|8|@]|9|@$P|1G|Q|1H|1|1I]]|A|$]]|$1|R|3|L|5|6|7|1J|8|@]|9|@]|A|$]]|$1|S|3|T|5|6|7|1K|8|@]|9|@]|A|$]]|$1|U|3|V|5|6|7|1L|8|@]|9|@]|A|$]]|$1|W|3|L|5|6|7|1M|8|@]|9|@]|A|$]]|$1|X|3|N|5|O|7|1N|8|@]|9|@$P|1O|Q|1P|1|1Q]]|A|$]]|$1|Y|3|L|5|6|7|1R|8|@]|9|@]|A|$]]|$1|Z|3|-4|5|6|7|1S|8|@]|9|@]|A|$]]]|10|$11|$5|12|13|14|A|$15|16|17|-4]]|18|$5|12|13|14|A|$15|19|17|-4]]]]

I am using Visual Studio Community 2013.

I had same error:

You can fix it by updating the SQL Server Tools:

<pre><code>Tools --&gt; Extensions and Updates
</code></pre>

<a href="https://i.stack.imgur.com/UueZh.png" rel="noreferrer"><img src="https://i.stack.imgur.com/UueZh.png" alt="enter image description here"></a>

Then under Product Updates you will see an option to update SQL Server Update.

Click on Update, after it has installed restart Visual Studio.

<a href="https://i.stack.imgur.com/AUmig.png" rel="noreferrer"><img src="https://i.stack.imgur.com/AUmig.png" alt="enter image description here"></a>

blocks|key|149198|text|尝试：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|149199|149200|从http://go.microsoft.com/fwlink/?LinkID=393521|ordered-list-item|offset|length|149201|安装最新的http://www.microsoft.com/en-us/download/details.aspx?id=43370+|149202|重新安装最新的固态硬盘|unordered-list-item|149203|149204|来源：VS2013+SqlBuildTask+04018+Error|149205|entityMap|0|LINK|mutability|MUTABLE|url|http://go.microsoft.com/fwlink/?LinkID=393521|1|http://www.microsoft.com/en-us/download/details.aspx?id=43370|2|https://connect.microsoft.com/SQLServer/feedbackdetail/view/979839^0|0|0|1|19|0|0|5|1P|1|0|0|0|3|V|2|0^^$0|@$1|2|3|4|5|6|7|11|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|12|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|13|8|@]|9|@$F|14|G|15|1|16]]|A|$]]|$1|H|3|I|5|6|7|17|8|@]|9|@$F|18|G|19|1|1A]]|A|$]]|$1|J|3|K|5|L|7|1B|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|1C|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|1D|8|@]|9|@$F|1E|G|1F|1|1G]]|A|$]]|$1|P|3|-4|5|6|7|1H|8|@]|9|@]|A|$]]]|Q|$R|$5|S|T|U|A|$V|W]]|X|$5|S|T|U|A|$V|Y]]|Z|$5|S|T|U|A|$V|10]]]]

Try:

<ol>
<li>Install the latest DacFx from <a href="http://www.microsoft.com/en-us/download/details.aspx?id=43370">http://www.microsoft.com/en-us/download/details.aspx?id=43370</a> </li>
<li>Reinstall the latest SSDT from <a href="http://go.microsoft.com/fwlink/?LinkID=393521">http://go.microsoft.com/fwlink/?LinkID=393521</a></li>
</ol>

Source: <a href="https://connect.microsoft.com/SQLServer/feedbackdetail/view/979839">VS2013 SqlBuildTask 04018 Error</a>

blocks|key|150690|text|我在MSDN订阅者下载中搜索了"Visual+Studio+2013+Update+2“，它就在那里|type|unstyled|depth|inlineStyleRanges|entityRanges|data|150691|另外，我向MS+VS2013+SqlBuildTask+04018+Error提交了一个bug，如果您遇到同样的问题，请投赞成票|offset|length|150692|entityMap|0|LINK|mutability|MUTABLE|url|https://connect.microsoft.com/SQLServer/feedbackdetail/view/979839^0|0|8|V|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@$D|P|E|Q|1|R]]|A|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|M]]]]

I searched "Visual Studio 2013 Update 2" in MSDN subscriber downloads and it was there

Also I filed a bug with MS
<a href="https://connect.microsoft.com/SQLServer/feedbackdetail/view/979839" rel="nofollow">VS2013 SqlBuildTask 04018 Error</a> Please up vote it if you are getting the same problem

blocks|key|2731195|text|我也有同样的问题。我试着修复Visual+Studio+2013、update+4、SSDT、DAC工具等，但效果并不好。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2731196|然而，我注意到C:\Program+Files+(x86)\MSBuild\Microsoft\VisualStudio\v12.0\SSDT中的Microsoft.Data.Tools.Schema.SqlTasks.targets文件是2013年的(实际上它对应于旧的SSDT)。因此，我所做的就是复制新的(我在C:\Program+Files+(x86)\MSBuild\Microsoft\VisualStudio\v11.0\SSDT中意外地发现了它...)转到这个v12.0\SSDT文件夹，重新启动Visual+Studio+2013，现在它可以工作了。作为参考，新的SSDT目标文件的日期为2014/10/26，大小为75437字节。|offset|length|style|CODE|2731197|entityMap^0|0|7|1S|21|18|4E|1S|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@$D|L|E|M|F|G]|$D|N|E|O|F|G]|$D|P|E|Q|F|G]]|9|@]|A|$]]|$1|H|3|-4|5|6|7|R|8|@]|9|@]|A|$]]]|I|$]]

I had the same issue. I tried to repair Visual Studio 2013, update 4, SSDT, the DAC tools, etc., but it didn't work any better.

However I noticed the <code>Microsoft.Data.Tools.Schema.SqlTasks.targets</code> file present in <code>C:\Program Files (x86)\MSBuild\Microsoft\VisualStudio\v12.0\SSDT</code> was dated from 2013 (In fact it corresponded to the old SSDT). So what I did is just copy the new one (which I suprisingly found in <code>C:\Program Files (x86)\MSBuild\Microsoft\VisualStudio\v11.0\SSDT</code> ...) over to this v12.0\SSDT folder, restarted Visual Studio 2013 and now it works. For information, that new SSDT targets file is dated from 2014/10/26 and its size is 75437 bytes.

blocks|key|2731239|text|我已经安装了最新版本的SQL+Data+Tools，但在安装VS2015+RC之后，它停止了工作。在SSDT上运行修复后，它再次成功编译。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2731240|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I already had the newest Version of SQL Data Tools installed, but after installing VS2015 RC it stopped to work. After run a repair on SSDT it compiles again with success.

blocks|key|2731280|text|我安装了Visual+Studio+2013+Update+5，遇到了这个问题。我按照上面的步骤操作，这解决了我的问题-->|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2731281|在Visual+Studio2013+->+Tools+->扩展和更新中...->更新->产品更新->数据库的Microsoft+SQL+Server更新至12.0.50730.0|2731282|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

I had Visual Studio 2013 Update 5 installed and was having this issue. I followed these steps from above and that fixed the issue for me -->

In Visual Studio 2013 -> Tools -> Extensions and Updates... -> Updates -> Product Updates -> Microsoft SQL Server Update for database to 12.0.50730.0

blocks|key|2731388|text|我也遇到了同样的问题，只需重新启动Visual+Studio，它就能为我工作。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2731389|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I had the same issue and just restart the Visual Studio and it works for me.

blocks|key|147934|text|如果对任何人有帮助的话，我安装了VS2014+CTP3，我可以用它来构建。有趣的是，在vs2014中成功构建之后，下次在VS2013中构建时，它就可以工作了。但是，在VS2014中重新构建之前，VS2013中的后续构建是不起作用的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|147935|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

If it helps anybody, I installed VS2014 CTP 3, and I can build from it. Interestingly after a successfull build in vs2014, the next time you build in VS2013 it works. But subsequent builds in VS2013 dont work, until you rebuild in VS2014.

blocks|key|148071|text|通过修复Microsoft+SQL+Server数据工具并重新启动Visual+Studio+2013，我解决了这个问题。控制面板>右键单击："Microsoft+SQL+Server+Data+Tools“>单击："Repair”>重新启动Visual+Studio|type|unstyled|depth|inlineStyleRanges|entityRanges|data|148072|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I was able to fix the issue by repairing Microsoft SQL Server Data Tools and re-starting Visual Studio 2013.
Control Panel > Right Click: "Microsoft SQL Server Data Tools" > Click: "Repair" > Re-Start Visual Studio

blocks|key|148074|text|我也有同样的问题。运行磁盘检查，然后重新启动解决了这个问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|148075|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I had the same issue. Running disk check and then rebooting fixed it.

blocks|key|2943774|text|我遇到了同样的问题，使用的堆栈跟踪略有不同：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2943775|2943776|错误MSB4018："SqlBuildTask“任务意外失败。System.IO.IOException:文件存在。|blockquote|2943777|2943778|2943779|事实证明这是我使用的服务帐户的临时目录的问题，我认为如果该目录中的文件夹/文件数超过X，则发布将不再有效。通过遵循instructions+mentioned+here+(适用于我的服务帐户)修复此问题：|offset|length|2943780|2943781|Go+start->+run|unordered-list-item|2943782|Type%25TEMP%25并单击ok|2943783|确保您位于文件夹/Local/Temp|2943784|Delete+everything+in+中|2943785|2943786|entityMap|0|LINK|mutability|MUTABLE|url|https://social.msdn.microsoft.com/Forums/vstudio/en-US/602ed2db-80f8-44ae-98e6-f6b940da905e/visual-studio-build-failing-for-all-build-instances?forum=tfsbuild^0|0|0|0|0|0|1L|R|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|14|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|15|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|16|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|17|8|@]|9|@]|A|$]]|$1|G|3|-4|5|6|7|18|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|19|8|@]|9|@$J|1A|K|1B|1|1C]]|A|$]]|$1|L|3|-4|5|6|7|1D|8|@]|9|@]|A|$]]|$1|M|3|N|5|O|7|1E|8|@]|9|@]|A|$]]|$1|P|3|Q|5|O|7|1F|8|@]|9|@]|A|$]]|$1|R|3|S|5|O|7|1G|8|@]|9|@]|A|$]]|$1|T|3|U|5|O|7|1H|8|@]|9|@]|A|$]]|$1|V|3|-4|5|6|7|1I|8|@]|9|@]|A|$]]|$1|W|3|-4|5|6|7|1J|8|@]|9|@]|A|$]]]|X|$Y|$5|Z|10|11|A|$12|13]]]]

I experienced the same issue with a slightly different stack trace:
<blockquote>
Error MSB4018: The &quot;SqlBuildTask&quot; task failed unexpectedly.
System.IO.IOException: The file exists.
</blockquote>
Turns out this is a issue with the Temp directory for the service account I was using, I think if you exceed X number of folders/files in that directory the publish will no longer work. Fixed this issue by following the <a href="https://social.msdn.microsoft.com/Forums/vstudio/en-US/602ed2db-80f8-44ae-98e6-f6b940da905e/visual-studio-build-failing-for-all-build-instances?forum=tfsbuild" rel="nofollow noreferrer">instructions mentioned here</a> (for my service account):
<ul>
<li>Go start-&gt; run</li>
<li>Type %temp% and click ok</li>
<li>Make sure you are in the folder /Local/Temp</li>
<li>Delete everything in this folder</li>
</ul>

blocks|key|2731244|text|我得到了相同的错误，并通过重新安装Visual+Studio+2015修复了它|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2731245|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I got the same error and fix it by re-install Visual Studio 2015

blocks|key|2731445|text|我遇到了这个问题，并像这样解决了它：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2731446|从http://www.microsoft.com/en-us/download/details.aspx?id=43370安装最新的|offset|length|2731447|+DacFx|ordered-list-item|2731448|2731449|从C:\Program+Files+(x86)\MSBuild\Microsoft\VisualStudio\v12.0\SSDT中删除|2731450|+Microsoft.Data.Tools.Schema.SqlTasks.targets文件|2731451|2731452|2731453|repair+SQL+Server+Data+Tools+2013，reset+visual+studio()|unordered-list-item|2731454|2731455|entityMap|0|LINK|mutability|MUTABLE|url|http://www.microsoft.com/en-us/download/details.aspx?id=43370^0|0|1|1P|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|11|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|12|8|@]|9|@$D|13|E|14|1|15]]|A|$]]|$1|F|3|G|5|H|7|16|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|17|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|18|8|@]|9|@]|A|$]]|$1|L|3|M|5|H|7|19|8|@]|9|@]|A|$]]|$1|N|3|-4|5|6|7|1A|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|1B|8|@]|9|@]|A|$]]|$1|P|3|Q|5|R|7|1C|8|@]|9|@]|A|$]]|$1|S|3|-4|5|6|7|1D|8|@]|9|@]|A|$]]|$1|T|3|-4|5|6|7|1E|8|@]|9|@]|A|$]]]|U|$V|$5|W|X|Y|A|$Z|10]]]]

I had this problem and fixed it like this:
<ol>
<li>install the latest DacFx from <a href="http://www.microsoft.com/en-us/download/details.aspx?id=43370" rel="nofollow noreferrer">http://www.microsoft.com/en-us/download/details.aspx?id=43370</a>
</li>
<li>Delete the Microsoft.Data.Tools.Schema.SqlTasks.targets file from C:\Program Files (x86)\MSBuild\Microsoft\VisualStudio\v12.0\SSDT
</li>
</ol>
<ul>
<li>repair SQL Server Data Tools 2013 , reset visual studio()</li>
</ul>

I've got a database project as part of my solution in Visual Studio 2013. Been working perfectly for the last 3 weeks and now suddenly today it won't build and so I cannot publish any changes. I'm getting an MSBuild error: 

<blockquote>
 "C:\Program Files
 (x86)\MSBuild\Microsoft\VisualStudio\v12.0\SSDT\Microsoft.Data.Tools.Schema.SqlTasks.targets(513,5):
 Error: MSB4018: The "SqlBuildTask" task failed unexpectedly.
 System.MethodAccessException: Attempt by method 'Microsoft.Data.Tools.Schema.Sql.Build.SqlTaskHost.OnCreateCustomSchemaData(System.String,
 System.Collections.Generic.Dictionary`2)'
 to access method
 'Microsoft.Data.Tools.Components.Diagnostics.SqlTracer.ShouldTrace(System.Diagnostics.TraceEventType)'
 failed."
</blockquote>

Anyone got any ideas? All I did this morning was pull down the latest changes from source control. I can't see how that would mess up the actual <code>MSBuild</code> process, and the guy who checked in last doesn't have any issues at all.

Visual Studio 2013: Database Project MSBuild error

Visual Studio

SQL Server

数据库

我在Visual Studio 2013中有一个数据库项目作为我的解决方案的一部分。在过去的3周里我一直工作得很好，现在突然它不能构建了，所以我不能发布任何更改。我收到一个MSBuild错误：(x86)\MSBuild\Microsoft\VisualStudio\v12.0\SSDT\Microsoft.Data.Tools.Schema.SqlTasks.targets(513,5)："C:\

问Visual Studio 2013:数据库项目MSBuild错误
EN

回答 16

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Visual Studio 2013:数据库项目MSBuild错误EN

回答 16

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Visual Studio 2013:数据库项目MSBuild错误
EN