title: Connecting to SFTP via SSIS
body: <p>I'm trying to connect to a <code>SFTP</code> server via an <code>SSIS</code> package. The package executes <code>WinSCP</code> with the following connection string in a <code>.txt</code> file: </p>
  
  <pre><code>open sftp://username:fc$#6444@example.com:22
  </code></pre>
  
  <p>However the package keeps failing without being able to connect. Is it something to do with the special characters in the password? </p>
  
  <p>I am able to connect to a different SFTP if I replace the string so I know it must be something to do with the syntax above. I've tried putting double quotes around the string as follows without any success:</p>
  
  <pre><code>open "sftp://username:fc$#6444@example.com:22"
  </code></pre>