You have a few options..
One is tools like CozyRoc, it has its own SFTP task to make things simple.
Another is to use WINSCP and shell out using the scripting components it allows you to carry out.
Or, just a quick search brough up SSC article
answered Jun 19, 2011 at 08:10 AM