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.
| 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.RegardsKishore |
|
|
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-sharpI assume you are able to wrap this in a script component.fyi there are lots of other SFTP libraries out there |
 |
|
|
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.RegardsKishore |
|
|
|
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 |
|
|
|
|
|
|
Script Task to download latest text file from SFTP