Topic "Send Proxy info from SQL sproc"

Author Message
steveosacky
[View user's profile]

Joined: 2014-05-16
Posts: 1
Location: United States
I have this WinSCP connection info scripted in a SQL sproc that gets sent to a file for the WinSCP connection. I have an environment that requires the advanced settings Proxy account info to connect. How can I add the proxy info in the SQL scripting? Can it be passed in this string with connection info? Or is there a better way to accomplish this requirement?

SET @SFTPString = 'open sftp://USERNAME:' + @Password + '@sftp.SITE.com -hostkey="ssh-dss 1024 22:33:44:55:33:3f:13:40:46:66:21:8f:7c:71:8e:02"'
martin
[View user's profile]
Site Admin
Joined: 2002-12-10
Posts: 24995
Location: Prague, Czechia
Please read documentation:
https://winscp.net/eng/docs/rawsettings

If that does not help, come back.
_________________
Martin Prikryl
Guest




The following solution worked. Thanks.

SET @SFTPString = 'open sftp://benchmarkuser:' + @Password + '@sftp.com -hostkey="ssh-dss 1024 79:77:44:33:55:3f:13:40:46:66:21:8f:7c:71:8e:02" -rawsettings ProxyMethod=3 ProxyHost=10.423.2.12 ProxyPort=4011 ProxyUsername="USER" ProxyPassword="PASS"'
Advertisements

You can post new topics in this forum






Search Site

What is WinSCP?

It is award-winning SFTP client, SCP client, FTPS client and FTP client integrated into one software program for file transfer to FTP server or secure SFTP server. [More]

And it's free!

Donate

About donations

$9   $19   $49   $99

About donations

Recommend

WinSCP Privacy Policy

WinSCP License