Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 SSIS and Import/Export (2012)
 Script Task to download latest text file from SFTP

Author  Topic 

kishoremcp
Starting Member

41 Posts

Posted - 2015-01-13 : 10:45:31
Hi,

I have an SFTP where there will be n number of files from which i have to download the latest file to a local computer folder.
I cannot use any 3rd party tools like WinSCP or FileZilla. Please help me with any script task to achieve this.

Regards,
Kishore.

Regards
Kishore

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2015-01-13 : 11:45:26
Found this:

SharpSSH for sftp, it works well and is open source.

Code example:

sftp = new Tamir.SharpSsh.Sftp(ipAddress, username, password);
sftp.Connect();
sftp.Get(sourcePath, destinationPath);
sftp.Close();

here: http://stackoverflow.com/questions/8092180/how-to-use-sftp-in-c-sharp

I assume you are able to wrap this in a script component.

fyi there are lots of other SFTP libraries out there
Go to Top of Page

kishoremcp
Starting Member

41 Posts

Posted - 2015-01-13 : 22:54:09
Hi Gbritton,

I am very new to SSIS. So, could you please guide me on this step by step. It would be very helpful.

Regards,
Kishore.

Regards
Kishore
Go to Top of Page

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2015-01-14 : 07:23:00
Google ssis script component transformation input output. Lots of tutorials and info out there
Go to Top of Page
   

- Advertisement -