I had the need for several automated jobs to be able to exchange files securely with partners via the Secure FTP (SFTP). I chose powershell because the jobs:
get executed on windows nodes. It is less overhead than creating console apps in .NET
required things like querying databases, transforming data, and archiving files
I spent a little bit of time looking into different options, and decided to utilize the latest version of the WinSCP library provided the required options...
[More]