I figured it out. I looked in the
Microsoft.Data.Tools.Schema.SqlTasks.targets file and found where SqlTargetPath is being set. It is only being set to the TargetDir if SqlTargetPath is empty.
<SqlTargetPath Condition=" '$(SqlTargetPath)' == '' ">$(TargetDir)$(SqlTargetFile)</SqlTargetPath>
Therefore, to fix this I set the property SqlTargetPath in the sqlproj file as shown below. Right now, I'm setting for local builds and TFS builds. I still plan on adding a condition so it is only done on the TFS Server.
Under
<PropertyGroup>
<Configuration
Condition="
'$(Configuration)' == '' ">Debug</Configuration>
Added
<SqlTargetPath>$(MSBuildProjectDirectory)\$(MSBuildProjectName).dacpac</SqlTargetPath>
I hope it helps someone else out too.
Mike
blog - http://www.codesmartnothard.com