SFTP download file

• coool_sweet

  SSCommitted

  Points: 1892

  More actions

  July 11, 2017 at 4:50 pm

  #338849

  hi
  i have 1 sftp site example, http://sftp.newname.com

  i ma using my user name and password to login that site, once i am there under there there is 1 folder , under that there is 4 folder.

  in this 4 folder vendor is putting files daily , so i need to download those files from it to my local shared drive.

  how to do it , i dont have sftp installed any .net code?

• Tim Mitchell

  SSCoach

  Points: 15681

  More actions

  July 11, 2017 at 4:54 pm

  #1950454

  I wrote a blog post a while back on working with SFTP through SSIS: https://www.timmitchell.net/post/2015/08/03/accessing-sftp-with-ssis/

  Tim Mitchell, Microsoft Data Platform MVP
  Data Warehouse and ETL Consultant
  TimMitchell.net | @Tim_Mitchell | Tyleris.com
  ETL Best Practices