I’ve used each of these solutions in the past, and each one has its own merits and risks. Develop a code-based solution that calls a command-line SFTP application.Develop a purely code-based solution using a third-party DLL.Acquire a third-party SSIS task suited for this purpose (of which there are several free and paid versions).Possible Solutionsīefore I dive into my solution, I’ll point out that there are several ways to solve the problem of downloading files stored on SFTP with SSIS: In this post, I’ll show how to access SFTP with SSIS by building a reusable package to download secure FTP files. However, it is possible to build your own solution using free tools and a bit of code.

There is a built-in FTP task in Integration Services, but it is very limited in its functionality and will not connect to an SFTP server. If you’ve used SSIS for any significant amount of time, you’ve almost certainly run into this roadblock: You need to download a file stored on an SFTP (secure FTP) server, but connecting to SFTP with SSIS is not natively supported.

Filezilla server setup sftp 2015