SSDT

Karen's Avatar

Karen

16 Mar, 2014 01:49 AM

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]"

  1. Support Staff 1 Posted by Feodor Fitsner on 16 Mar, 2014 01:53 AM

    Feodor Fitsner's Avatar

    Hi Karen,

    Do you know what package should be installed on build machine to make this work?

  2. 2 Posted by Karen Abgaryan on 17 Mar, 2014 01:06 PM

    Karen Abgaryan's Avatar

    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

  3. Support Staff 3 Posted by Feodor Fitsner on 17 Mar, 2014 04:39 PM

    Feodor Fitsner's Avatar

    Thank you!

  4. Support Staff 4 Posted by Feodor Fitsner on 17 Mar, 2014 09:13 PM

    Feodor Fitsner's Avatar

    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.

  5. Support Staff 5 Posted by Feodor Fitsner on 12 Dec, 2014 03:54 AM

    Feodor Fitsner's Avatar

    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

  6. Ilya Finkelshteyn closed this discussion on 25 Aug, 2018 01:50 AM.

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