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_

Script task and then just copy the code here: http://social.msdn.microsoft.com/Forums/en/ncl/thread/079fb811-3c55-4959-85c4-677e4b20bea3Chuck

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

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

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

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