Guide on SSIS SFTP.....

• nd.lokesh008

  Grasshopper

  Points: 21

  More actions

  September 5, 2013 at 4:07 am

  #277654

  Hi Forum,

  I am in very urgency to implement SSIS Package in my Project , As the client upload's the file using SFTP & There is no task available in SSIS to download file's from SFTP. Can any one guide me on how to implement this task in my package..

  Thanks in advance......

• BrainDonor

  SSCoach

  Points: 19254

  More actions

  September 5, 2013 at 6:01 am

  #1647668

  We've used a Script Task to call WinSCP, not pretty but it works.

  Steve Hall
  Linkedin
  Blog Site

• pshields

  SSC Veteran

  Points: 213

  More actions

  September 6, 2013 at 6:04 am

  #1648027

  We are using WinSCP and the below blog post was very helpful.

  http://www.bidn.com/blogs/KeithHyer/bidn-blog/633/winscp-from-ssis-secure-ftp-transfers

• COZYROC

  One Orange Chip

  Points: 28499

  More actions

  September 7, 2013 at 7:44 am

  #1648332

  The easiest option is to use third-party task like the commercial COZYROC SFTP Task. The task is very similar to the standard FTP Task and supports both FTPS and SSH secure protocols.

  ---
  SSIS Tasks Components Scripts Services | http://www.cozyroc.com/