Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Guide on SSIS SFTP..... Expand / Collapse
Author
Message
Posted Thursday, September 5, 2013 4:07 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, October 14, 2013 11:48 PM
Points: 1, Visits: 7
Hi Forum,

I am in very urgency to implement SSIS Package in my Project , As the client upload's the file using SFTP & There is no task available in SSIS to download file's from SFTP. Can any one guide me on how to implement this task in my package..


Thanks in advance......


Post #1491694
Posted Thursday, September 5, 2013 6:01 AM


UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: 2 days ago @ 7:54 AM
Points: 1,475, Visits: 8,470
We've used a Script Task to call WinSCP, not pretty but it works.

BrainDonor
Linkedin
Blog Site
Post #1491737
Posted Friday, September 6, 2013 6:04 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, July 2, 2014 3:56 PM
Points: 11, Visits: 379
We are using WinSCP and the below blog post was very helpful.
http://www.bidn.com/blogs/KeithHyer/bidn-blog/633/winscp-from-ssis-secure-ftp-transfers
Post #1492180
Posted Saturday, September 7, 2013 7:44 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Sunday, September 14, 2014 3:17 PM
Points: 1,118, Visits: 2,224
The easiest option is to use third-party task like the commercial COZYROC SFTP Task. The task is very similar to the standard FTP Task and supports both FTPS and SSH secure protocols.

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Post #1492530
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse