Process works VS on App Server but fails in SSIS on SQL Server

Advertisement

vschexnayder
Joined:
Posts:
1

Process works VS on App Server but fails in SSIS on SQL Server

Hi, I am using SSIS with an execute process task. The package executes and transfers the file when ran on VS on my application server. WinSCP is installed on the application server. For SSIS automation, the job is on the SQL Server. The package executes WinSCP on the application server. I am using a proxy with my credentials for the Job.

So far I have tried using script files on both servers, .ini files on both servers in folder and user data, working directory on both servers but keep getting the same error.

At this point loading WinSCP on SQL Server is not an option.

SSIS Execute Process task:
Executable - \\AppServer.Company.org\C$\abcwua\winscp\WinSCP.exe
Arguments - script=C:\Folder\winscp\Arguments\TeamTestFTP.txt /log=C:\Folder\winscp\logfile.log
Working Directory - \\AppServer.Company.org\C$\Windows\system32

Log File:
2024-06-28 11:54:59.894 --------------------------------------------------------------------------
. 2024-06-28 11:54:59.910 WinSCP Version 6.3.4 (Build 14955 2024-06-17) (OS 10.0.17763 – Windows Server 2019 Standard)
. 2024-06-28 11:54:59.910 Configuration: \\AppServer.Domain.org\C$\Folder\winscp\WinSCP.ini
. 2024-06-28 11:54:59.910 Log level: Normal
. 2024-06-28 11:54:59.910 Local account: Domain\username
. 2024-06-28 11:54:59.910 Working directory: \\AppServer.domain.org\C$\Windows\system32
. 2024-06-28 11:54:59.910 Process ID: 7720
. 2024-06-28 11:54:59.926 Ancestor processes: ISServerExec, sqlservr, ...
. 2024-06-28 11:54:59.926 Command-line: "\\AppServer.company.org\C$\Folder\winscp\WinSCP.exe" /script=C:\Folder\winscp\Arguments\TeamTestFTP.txt  /log=C:\Folder\winscp\logfile.log
. 2024-06-28 11:54:59.926 Time zone: Current: GMT-6, Standard: GMT-7 (Mountain Standard Time), DST: GMT-6 (Mountain Daylight Time), DST Start: 3/10/2024, DST End: 11/3/2024
. 2024-06-28 11:54:59.926 Login time: Friday, June 28, 2024 11:54:59 AM
. 2024-06-28 11:54:59.926 --------------------------------------------------------------------------
. 2024-06-28 11:54:59.926 Script: Retrospectively logging previous script records:
> 2024-06-28 11:54:59.926 Script: open sftp://Team:***@SFTP.Company.org/ -hostkey="ssh-rsa 3072 wUGlce......Y2+siyT+PIsMIwHHNhpvm/Bc00fo="
. 2024-06-28 11:54:59.926 --------------------------------------------------------------------------
. 2024-06-28 11:54:59.926 Session name: FTPUser@SFTP.company.org (Ad-Hoc site)
. 2024-06-28 11:54:59.926 Host name: SFTP.company.org (Port: 22)
. 2024-06-28 11:54:59.926 User name: Team (Password: Yes, Key file: No, Passphrase: No)
. 2024-06-28 11:54:59.926 Tunnel: No
. 2024-06-28 11:54:59.926 Transfer Protocol: SFTP
. 2024-06-28 11:54:59.926 Ping type: Off, Ping interval: 30 sec; Timeout: 15 sec
. 2024-06-28 11:54:59.926 Disable Nagle: No
. 2024-06-28 11:54:59.926 Proxy: None
. 2024-06-28 11:54:59.926 Send buffer: 262144
. 2024-06-28 11:54:59.926 Compression: No
. 2024-06-28 11:54:59.926 Bypass authentication: No
. 2024-06-28 11:54:59.926 Try agent: Yes; Agent forwarding: No; KI: Yes; GSSAPI: Yes
. 2024-06-28 11:54:59.926 GSSAPI: KEX: No; Forwarding: No; Libs: gssapi32,sspi,custom; Custom: 
. 2024-06-28 11:54:59.926 Ciphers: aes,chacha20,aesgcm,3des,WARN,des,blowfish,arcfour; Ssh2DES: No
. 2024-06-28 11:54:59.926 KEX: ntru-curve25519,ecdh,dh-gex-sha1,dh-group18-sha512,dh-group17-sha512,dh-group16-sha512,dh-group15-sha512,dh-group14-sha1,rsa,WARN,dh-group1-sha1
. 2024-06-28 11:54:59.926 SSH Bugs: Auto,Auto,Auto,Auto,Auto,Auto,Auto,Auto,Auto,Auto
. 2024-06-28 11:54:59.926 Simple channel: Yes
. 2024-06-28 11:54:59.926 Return code variable: Autodetect; Lookup user groups: Auto
. 2024-06-28 11:54:59.926 Shell: default
. 2024-06-28 11:54:59.926 EOL: LF, UTF: Auto
. 2024-06-28 11:54:59.926 Clear aliases: Yes, Unset nat.vars: Yes, Resolve symlinks: Yes; Follow directory symlinks: No
. 2024-06-28 11:54:59.926 LS: ls -la, Ign LS warn: Yes, Scp1 Comp: No; Exit code 1 is error: No
. 2024-06-28 11:54:59.926 SFTP Bugs: Auto,Auto
. 2024-06-28 11:54:59.926 SFTP Server: default
. 2024-06-28 11:54:59.926 Local directory: default, Remote directory: home, Update: Yes, Cache: Yes
. 2024-06-28 11:54:59.926 Cache directory changes: Yes, Permanent: Yes
. 2024-06-28 11:54:59.926 Recycle bin: Delete to: No, Overwritten to: No, Bin path: 
. 2024-06-28 11:54:59.926 DST mode: Unix
. 2024-06-28 11:54:59.926 --------------------------------------------------------------------------
< 2024-06-28 11:54:59.926 Script: Searching for host...
. 2024-06-28 11:54:59.926 Looking up host "SFTP.company.org" for SSH connection
. 2024-06-28 11:54:59.942 Connecting to xxx.xxx.xxx.xxx port 22
. 2024-06-28 11:54:59.942 Failed to connect to xxx.xxx.xxx.xxx: Network error: Permission denied
< 2024-06-28 11:54:59.942 Script: Network error: Permission denied

Reply with quote

Advertisement

martin
Site Admin
martin avatar
Joined:
Posts:
40,984
Location:
Prague, Czechia

Re: Process works VS on App Server but fails in SSIS on SQL Server

You do not have a network connectivity from the SQL server machine/account to the SFTP server.
This is not about any WinSCP script or configuration.
It's networking problem. Please talk to your server/network administrator.

Reply with quote

Advertisement

You can post new topics in this forum