SSDT
Hi, can you help me with SSDT project in VS 2013? SSDT project in my solution compiled with
"error MSB4062: The "SqlModelResolutionTask" task could not be loaded from the assembly C:\Program Files (x86)\Microsoft SQL Server\110\DAC\Bin\Microsoft.Data.Tools.Schema.Tasks.Sql.12.dll. Could not load file or assembly 'file:///C:\Program Files (x86)\Microsoft SQL Server\110\DAC\Bin\Microsoft.Data.Tools.Schema.Tasks.Sql.12.dll' or one of its dependencies. The system cannot find the file specified. Confirm that the declaration is correct, that the assembly and all its dependencies are available, and that the task contains a public class that implements Microsoft.Build.Framework.ITask. [C:\projects\slotmachines\SlotMachines.Db\SlotMachines.Db.sqlproj]"
Comments are currently closed for this discussion. You can start a new one.
Keyboard shortcuts
Generic
| ? | Show this help |
|---|---|
| ESC | Blurs the current field |
Comment Form
| r | Focus the comment reply box |
|---|---|
| ^ + ↩ | Submit the comment |
You can use Command ⌘ instead of Control ^ on Mac

Support Staff 1 Posted by Feodor Fitsner on 16 Mar, 2014 01:53 AM
Hi Karen,
Do you know what package should be installed on build machine to make this work?
2 Posted by Karen Abgaryan on 17 Mar, 2014 01:06 PM
Hi Feodor,
You can find list of package in
this<http://stackoverflow.com/questions/15556339/how-to-build-sqlproj-projects-on-a-build-server>
SO
answer.
С уважением,
Karen
Support Staff 3 Posted by Feodor Fitsner on 17 Mar, 2014 04:39 PM
Thank you!
Support Staff 4 Posted by Feodor Fitsner on 17 Mar, 2014 09:13 PM
Hi Karen,
SSDT comes integrated with Visual Studio 2013 Express (Desktop and Web), so that blog post is valid for VS 2012 and below.
However, for some reason those libraries were missing at the first place. Repair of Visual Studio 2013 installation brought them back.
It should be OK now - let me know if anything else is missing.
Support Staff 5 Posted by Feodor Fitsner on 12 Dec, 2014 03:54 AM
It's been deployed - new "SQL Database" deployment provider for publishing SSDT package to local/remote SQL Server and Azure SQL Database: http://www.appveyor.com/docs/deployment/sql-database-ssdt
Ilya Finkelshteyn closed this discussion on 25 Aug, 2018 01:50 AM.