[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1129
  • Last Modified:

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,
0
ravichand-sql
Asked:
ravichand-sql
1 Solution
 
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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now