SSIS本身不支持SFTP。

SSIS doesn't support SFTP natively.

WinSCP（免费）可以方便。
这是它的链接：用于SSIS / SSDT的SFTP任务

WinSCP (free of charge) could be handy. Here is its link: SFTP Task for SSIS/SSDT