title: using SqlCmd variables with dbDacFx provider of MsDeploy
body: <p>I am trying to use msdeploy using dbDacFx provider to deploy my dacpac file. This database project uses a variable named UserName to create logins and users etc. Value for this needs to be passed during deployment time.</p>
  
  <p>So i am doing something like ...</p>
  
  <pre><code>msdeploy.exe -verb:Sync -Source:dbDacFx="c:\dev\pmwuiservices\trunk\Build\database\Database.dacpac"-dest:dbDacFx="Data Source=localhost;Integrated Security=True;Database=UIConfig", -setParam:Kind=SqlCommandVariable,scope=dbDacFx,match=UserName,value="IIS AppPool\ASP.NET V4.0"
  </code></pre>
  
  <p>but i get the following ( and by the way the url in the error message does not exist)</p>
  
  <pre><code>Info: Adding MSDeploy.dbDacFx (MSDeploy.dbDacFx).
  Info: Adding database (data source=localhost;integrated security=True;database=U
  IConfig)
  Info: Creating deployment plan: Pending.
  Info: Verifying deployment plan: Pending.
  Info: Deploying package to database: Pending.
  Info: Creating deployment plan: Running.
  Info: Initializing deployment (Start)
  Info: Initializing deployment (Failed)
  Info: Creating deployment plan: Faulted.
  Info: Verifying deployment plan: Faulted.
  Info: Deploying package to database: Faulted.
  Error Code: ERROR_EXECUTING_METHOD
  More Information: Could not deploy package.
  Missing values for the following SqlCmd variables:UserName.
    Learn more at: http://go.microsoft.com/fwlink/?LinkId=221672#ERROR_EXECUTING_M
  ETHOD.
  Error: Could not deploy package.
  Error: Missing values for the following SqlCmd variables:UserName.
  Error count: 1.
  </code></pre>
  
  <p>how can one user SqlCmd variables with DbDacFx provider in MSDeploy ? </p>
  
  <p>thanks</p>