SSIS and your SFTP options

The SQL Server intergration Services (SSIS) has always had a FTP task but it is odd that it has never had an SFTP task (up to 2017). SFTP is the Secure File Transfer Protocol using the Secure Shell SSH. There are third party SFTP tasks that can be deployed to your Server running SSIS but the simplest way to use SFTP is through an execute process [...] Read more