Reg: SSIS package connection manager ( SFTP Server)

HI,

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 ???

Thks,
ravichand-sqlAsked:
Who is Participating?
 
AlexPaceCommented:
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: http://www.robo-ftp.com/help/3.8/the_hot_receive_feature.htm
0
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.