Topic "Send Proxy info from SQL sproc"

Author Message
[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 + ' -hostkey="ssh-dss 1024 22:33:44:55:33:3f:13:40:46:66:21:8f:7c:71:8e:02"'
[View user's profile]
Site Admin
Joined: 2002-12-10
Posts: 27106
Location: Prague, Czechia
Please read documentation:

If that does not help, come back.
Martin Prikryl

The following solution worked. Thanks.

SET @SFTPString = 'open sftp://benchmarkuser:' + @Password + ' -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"'

You can post new topics in this forum


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!


About donations

$9   $19   $49   $99

About donations


WinSCP Privacy Policy

WinSCP License