Reg: SSIS package connection manager ( SFTP Server)


I want to connect to SFTP server for getting a file to my local machine, so which connection manager should I use to connect SFTP server ???

Who is Participating?
You'll need external software to connect to an SFTP server.

One option is to set up a Robo-FTP script to automatically download files as they appear on the SFTP server.  Then your SSIS package can just pick them up from the local folder.

Here is a sample script that shows how to do it:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.