Load file from SFTP server using SSIS

• ravi@sql

  SSCrazy

  Points: 2121

  More actions

  November 23, 2015 at 3:50 am

  #399368

  HI Champs,

  I have a requirment where

  I need to load file from SFTP server to local uisnf SSIS.

  As i know there are no available component to load from SFTP server. So we need to create custom component for this. Somebody adviced to install ssis extension , but since am having SSIS2010 version it didnt installed.

  After that i installed WINSCP and manually am able to download file from that. I want make it as automated using script task.

  We can make use of Eecute process task for this. But in many sites its not clear about the argumrnts what we need to pass.

  So please anybody can guide me to resolve this challenge clearly ? how to deal with this Winscp ?

  Regards,

  Ravi 🙂

• michal.lisinski

  SSCertifiable

  Points: 6933

  More actions

  November 24, 2015 at 2:43 am

  #1841962

  Hi Ravi

  My package uploads files on SFTP server. I prepared simple batch

  "C:\Program Files (x86)\WinSCP\WinSCP.exe" /console /script=upl_conf.txt

  and fire it with Execute Process Task (look for attached image).

  Best regards,

  Mike