"SSIS has a built-in feature for FTP, but point to be noted here is that Integration Services has native support for only FTP and not SFTP. "

Yes, this is unfortunately. Many customers are preferred SFTP or FTPS protocols than just FTP for security reason. So, SSIS FTP task will have a quite limited usage. Since the SFTP and FTPS are more and more porpular, Microsoft should enhance their FTP task to support it.

Currently, I have to use Execute Process task with WinSCP command online to perform the FTPS or SFTP file transfer in SSIS package.

Thanks,

Charley