title: SFTP file transfer in SSIS
body: <p>I've read a whole bunch of different forums on this but cant seem to get mine to work. I need to transfer a file from my local machine to an SFTP server using SSIS. Here is what I've already done:</p>
  
  <ul>
  <li>I downloaded WinSCP</li>
  <li>Created a saved connection in WinSCP (<code>TS_NEW</code>)</li>
  <li>Open up that saved connection (to verify)</li>
  <li>Copied <code>WinSCP.exe</code> and <code>WinSCP.com</code> to the SSIS project folder</li>
  <li>Created Text file with the below script.</li>
  </ul>
  
  
  
  <pre><code>option batch on
  option confirm off
  open sftp://TS_NEW.com
  cd C:\Users\zaccheut\Documents\Analytics Project 2018\ThoughtSpot\SSIS File
  option transfer binary
  put FCT_DC_MONTH.csv  /export/xvdb1/skynet/File_Test
  exit
  </code></pre>
  
  <p><strong>In SSIS my Execute Process Task editor has this:</strong></p>
  
  <ul>
  <li><p>Executable: <code>C:\Users\zaccheut\Documents\Visual Studio 2012\Projects\Skynet Refreshes\Skynet Refreshes\WinSCP.com</code></p></li>
  <li><p>Arguments: <code>/script=C:\Users\zaccheut\Documents\Visual Studio 2012\Projects\Skynet Refreshes\Skynet Refreshes\local2remote.txt</code></p></li>
  </ul>
  
  <p>How do I test this in Command Line, and what am I doing wrong?</p>