title: Invalid file names when trying to deploy SSDT project with TeamCity 8
body: <p>I am trying to deploy Visual Studio 2012 SSDT project to Sql Server using TeamCity 8 and MSBuild Publish task but the deployment fails.</p>
  
  <p>When I look at TeamCity logs and use /v:diag switch in my build configuration I see that for unknown reason MSBuild searches for <em>MyProject</em><strong>.sqlproj</strong>.publish.sql and for <em>MyProject</em><strong>.sqlproj</strong>.dacpac files.</p>
  
  <p>The exact error:</p>
  
  <blockquote>
    <p>[SqlPublishTask] C:\Program Files (x86)\MSBuild\Microsoft\VisualStudio\v11.0\SSDT\Microsoft.Data.Tools.Schema.SqlTasks.targets(1233, 5): File "C:\Program Files\TeamCity\buildAgent\work\abf8bc05a2cfe7f\*MyProject*\bin\Debug\*MyProject*.sqlproj.dacpac" does not exist.</p>
  </blockquote>
  
  <p>The correct .sql and .dacpac files get generated (without the .sqlproj in the middel) in buildAgent/work/<em>identificator</em>/*MySolution*/<em>MyProject</em>/bin/Debug folder.</p>
  
  <p>My TeamCity build step is configured as follows:</p>
  
  <ul>
  <li>Runner type: MSbuild</li>
  <li>Build file path: <em>MyProject</em>/*MyProject*.sqlproj</li>
  <li>MSBuild version: 4.5</li>
  <li>MsBuild ToolsVersion: 4.0</li>
  <li>Run platform: 4.0</li>
  <li>Targets: Publish</li>
  <li>Command line parameters: <code>/p:SqlPublishProfilePath="Debug.publish.xml" /p:Configuration=Debug</code></li>
  </ul>
  
  <p>If I execute this from commandline I get no errors.</p>
  
  <p>Any ideas on how can I configure TeamCity to search for correct files or configure my project to generate the files that TeamCity is searching for.</p>
  
  <p>Or is my plan to use MSBuild's Publish task futile and I should utilise <code>sqlpackage.exe</code> instead?</p>
  
  <p><strong>UPDATE</strong></p>
  
  <p>After spending almost three days trying to figure this out I gave up and used <code>sqlpackage.exe</code> which works like a charm.
  But I would still be interested in an answer though, passing paths to executables in build servers seems a bit crude way to accomplish things. </p>