title: DTExec: How to use a semicolon within a parameter value for SSIS package
body: <p>I just learned from <a href="https://stackoverflow.com/questions/30899054/ssis-package-stuck-at-created-execution-status">this stack overflow post</a> that if parameters are not configured correctly (if you are missing a required parameter) when using DTExec to run a package from the command line, your package will forever be stuck in a "Created Execution" status, and never actually run.</p>
  
  <p>Some similar odd behavior is occurring when I have a semicolon <em>within</em> my SSIS package parameter when using DTExec. If there is a semicolon in a parameter, DTExec simply says:</p>
  
  <blockquote>
    <p>"The syntax of the command is incorrect."</p>
  </blockquote>
  
  <pre><code>DTExec.exe /ISSERVER "\SSISDB\Data Feeds\Data Feed Project\Data Feed.dtsx" /SERVER "." /parameter RequiredParameter(string);parameter;value;has;semicolons
  </code></pre>
  
  <p>What is the correct syntax? Escaping the semicolons does not seem to work.</p>