great post, I bookmarked it for my next project. I was also looking at scripting with winscp but I think this approach is more SSIS friendlier that custom scripting and calling winscp.

on a side note, it is a shame that microsoft still does not have native support for sftp in 2012 version.