Wednesday, 23 October 2013

Could not load file or assembly 'Microsoft.Data.Tools.Components' or one of its dependencies.

Error

Build 
MSBuild 
Db\Database.sqlproj 
_SetupSqlBuildInputs 
SqlModelResolutionTask 
C:\Program Files (x86)\MSBuild\Microsoft\VisualStudio\v11.0\SSDT\Microsoft.Data.Tools.Schema.SqlTasks.targets(395, 5): error MSB4018: The "SqlModelResolutionTask" task failed unexpectedly.
System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.Data.Tools.Components, Version=11.1.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.
File name: 'Microsoft.Data.Tools.Components, Version=11.1.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a'
   at Microsoft.Data.Tools.Schema.Sql.Extensibility.ToolingShim.DoDacFxCompatibilityTest()
   at Microsoft.Data.Tools.Schema.Tasks.Sql.DataTask.Execute()
   at Microsoft.Data.Tools.Schema.Tasks.Sql.SqlModelResolutionTask.Execute()
   at Microsoft.Build.BackEnd.TaskExecutionHost.Microsoft.Build.BackEnd.ITaskExecutionHost.Execute()
   at Microsoft.Build.BackEnd.TaskBuilder.<ExecuteInstantiatedTask>d__20.MoveNext()

WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].

Project Db\Database.sqlproj failed. 
Project CMS.sln failed. 

Solution

  1. download latest version of your ssdt http://msdn.microsoft.com/en-us/data/tools.aspx or http://msdn.microsoft.com/en-us/data/hh297027
  1. if you installing it on server download offline version(iso)
  2. inside you will be able to find file {ISO}\SSDT\X86\SSDTBUILDUTILITIES.MSI
  3. Execute this installation and problem is solved.