title: VSTS build doesn't pickup the dacpac file (hosted agent in cloud)
body: <p>I'm trying to use VSTS to deploy into my database, the problem is in one of the steps I need to pick up the dacpac file and deploy it to the Azure SQL server but it fails:
  in that step, I'm using "<strong>Execute Azure SQL: DacpacTask</strong>" which is provided by Microsoft in VSTS.
  there is a filed to do it which is called "<strong>DACPAC File</strong>" and the documentation said  to use it like this:</p>
  
  <blockquote>
    <p>$(agent.releaseDirectory)\AdventureWorksLT.dacpac</p>
  </blockquote>
  
  <p>but it gave me the below error:</p>
  
  <blockquote>
    <p>No files were found to deploy with search pattern
    d:\a\1\s\$(agent.releaseDirectory)\AdventureWorksLT.dacpac</p>
  </blockquote>
  
  <p>so I did a cheating and put the below value in it:</p>
  
  <blockquote>
    <p>d:\a\1\s\AdventureWorksLT.dacpac</p>
  </blockquote>
  
  <p>it does work but obviously, it won't work forever as I need to use an environment variable, something like :</p>
  
  <blockquote>
    <p>$(agent.releaseDirectory)\AdventureWorksLT.dacpac</p>
  </blockquote>
  
  <p>any suggestion? </p>