SFTP all files in remote folder

Question

Is there anyway to get all files in a folder from a SFTP server?  I use Execute Process Task and WinSCP but I'd need to know the file names ahead.  In this case, I don't know how many files are in the folder, just need to copy them all.

---

Ash_

Answer 1

Script task and then just copy the code here:

http://social.msdn.microsoft.com/Forums/en/ncl/thread/079fb811-3c55-4959-85c4-677e4b20bea3

---

Chuck

Answer 2

You would know the extension of files you want to copy assume, sojust use a wildcard character and it would work

*.txt

---

Abhinav

Answer 3

Always, Always have a mechanism to archive or move the loads to a seperate location once processed.

---

Please vote as helpful or mark as answer, if it helps
Cheers, Raunak | t: @raunakjhawar | My Blog

Answer 4

Hi Ash_,

You can use ForEach Loop Container with a File System Task inside to move files to another place, for details step, please refer to:
http://www.rafael-salas.com/2007/03/ssis-file-system-task-move-and-rename.html#!/2007/03/ssis-file-system-task-move-and-rename.html

Thanks,
Eileen

Answer 5

Hi Eileen,

This solution would not work here. File System Task does not support SFTP.

---

Please vote as helpful or mark as answer, if it helps
Cheers, Raunak | t: @raunakjhawar | My Blog