File Upload/Download SFTP/FTPS

EwaldP · Post by **EwaldP** » 11 Oct 2017, 06:53

Hi,

- has anybody experience with up/downloading files via sftp/ftps?
- do you use 3rd party tools?
- is there something I have to care for?

Thank you.

Best regards
Ewald

TDWiki YouTube Channel · Post by **Dave Rabelink** » 11 Oct 2017, 07:20

Do you mean programatically?

clemdoc · Post by **clemdoc** » 11 Oct 2017, 08:45

Hi,

I have used SSH.NET with C# and that worked pretty well. You could write an assembly with your required classes and create a COM Wrapper to use it with Team Developer. Regarding the latter, you should be able to find everything you need either in this forum or on the TDWiki.

hth, clem

EwaldP · Post by **EwaldP** » 11 Oct 2017, 11:59

@Dave.
sry for the weak description. Yes, programmatically.

@clemdoc
Thanks

Harald · Post by **Harald** » 11 Oct 2017, 13:00

Hi Ewald,

I use WinSCP for that. You can start it with a script file.

Call SalLoadAppAndWait( 'WinSCP.exe /script=WinSCPScript_Prod_Downloads.script /log=D:\\LogFiles\\WinSCP\\WinSCP_FTP_Download_Prod_' || SalFmtFormatDateTime( SalDateCurrent( ), 'yyyyMMddhhhhmmss' ) || '.txt', Window_NotVisible, nDummy )

WinSCPScript_Prod_Downloads.script is:

option batch on
option confirm off

open sftp://<user>:<password>@<host> -hostkey="ssh-rsa 1024 <xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx>" -rawsettings ProxyMethod=3 ProxyHost=<ip> ProxyPort=<port>

option transfer automatic

lcd D:\<mydir>
cd /<theirdir>

get *.*

close

exit

Kind regards
Harald

Post by **Igor Ivanovic** » 12 Oct 2017, 12:29

I'm using wodSFTP (dll version): http://www.weonlydo.com/SFTP/Help/
Not free, but easy to implement.
And there is an ActiveX and .NET version also.

EwaldP · Post by **EwaldP** » 29 May 2018, 13:28

Hi guys,

I decided an activeX component from http://www.chilkatsoft.com/ because the bundle offers some other helpful features.

fyi

Ewald

Team Developer SQLWindows Community Forum