title: Deploy .dacpac missing assembly reference
body: <p>I have an SSDT (Sql Server Database Project) which refers to an external .dll (C# Class Library) in order to provide some CLR functions.
  If I Deploy/Publish locally everything works fine but remotely, using Microsoft.SqlServer.Dac.DacPackage it bombs.</p>
  
  <p>The problem, after further investigation, is inside the .dacpac generated. Somehow my .dacpac file has an "hardcoded" reference path which refers to my local DEV environment but when it runs on TFS the source path is different.</p>
  
  <p>I deploy the .dacpac using this class:</p>
  
  <pre><code>    var file = FileFinder.GetFirstFile("MyFile.dacpac");
      var package = DacPackage.Load(file);
      var deployOptions = new DacDeployOptions
      {
          BlockOnPossibleDataLoss = false,
          CreateNewDatabase = true,
          IncludeCompositeObjects = true
      };
  
      var dacService = new DacServices(ApplicationConfiguration.GetConnection("MyConn"));            
  
      dacService.Deploy(
          package: package,
          targetDatabaseName: "MyDB", 
          upgradeExisting: true, 
          options: deployOptions);
  }
  </code></pre>
  
  <p>And remotely the error is always the same, even if the .dlls are in the same folder of the .dacpac file:</p>
  
  <pre><code>No file was supplied for reference Utilities.dll; 
  deployment might fail. 
  When C:\MyFile.dacpac was created, the original referenced file was located **C:\DEV\MAIN\UTILITIES.DLL**.
  </code></pre>
  
  <p>Which of course is my local dev path.</p>
  
  <p>I am using:
  <strong>DacDeployOptions.IncludeCompositeObjects</strong> but nothing changes.</p>