Below command from command file(.cmd) works without any issues. File has been sent to destination through SecureFX without any issues.
"C:\Program Files\VanDyke Software\Clients\sfxcl.exe" /Log "D:\Applications\SecureFX\sfxcl_direct2.log" /AcceptHostKeys /NOPROMPT "E:\Applications\feed.txt" "E:\Applications\feed.ok" /S "/servername" "/home/fidname/"
Same command when executed from SSIS script task gets struck in this step - "Available Remote Recv Macs = hmac-sha2-256,hmac-sha2-512" as per the SecureFX log(please refer below). SSIS package itself is stuck and runs forever.
After 8 minutes, I have stopped the SSIS execution, then again SecureFX logs entries further(refer that 8 minute difference in below log). It automatically closes the connection, opens the connection again and transfers successfully (refer below).
2022-11-04 11:00:28, 00001: Session(0x6D9C0001): Available Remote Send Macs = hmac-sha2-256,hmac-sha2-512
2022-11-04 11:00:28, 00001: Session(0x6D9C0001): Selected Send Mac = hmac-sha2-512
2022-11-04 11:00:28, 00001: Session(0x6D9C0001): Available Remote Recv Macs = hmac-sha2-256,hmac-sha2-512
2022-11-04 11:08:50, 00001: Session(0x6D9C0001): Selected Recv Mac = hmac-sha2-512
2022-11-04 11:08:50, 00001: Session(0x6D9C0001): Available Remote Compressors = none,zlib@openssh.com
2022-11-04 11:08:50, 00001: Session(0x6D9C0001): Selected Compressor = none
2022-11-04 11:08:50, 00001: Session(0x6D9C0001): Available Remote Decompressors = none,zlib@openssh.com
2022-11-04 11:08:50, 00001: Session(0x6D9C0001): Selected Decompressor = none
2022-11-04 11:08:50, 00001: Session(0x6D9C0001): Changing state from STATE_EXPECT_KEX_INIT to STATE_KEY_EXCHANGE
2022-11-04 11:08:50, 00001: Session(0x6D9C0001): SEND : KEXDH_INIT
2022-11-04 11:08:50, 00001: Session(0x6D9C0001): RECV: TCP/IP close
2022-11-03 16:04:09, 00001: Session(0x68140001): Changing state from STATE_KEY_EXCHANGE to STATE_CLOSED
2022-11-03 16:04:09, 00001: Session(0x68140001): Connected for 1435 seconds, 589 bytes sent, 429 bytes received
2022-11-03 16:04:19, 00001: Session(0x68140001): SSH2Core version 9.1.0.2579
2022-11-03 16:04:19, 00001: Session(0x68140001): FIPS mode enabled
2022-11-03 16:04:19, 00001: Session(0x68140001): Connecting to servername:22 ...
2022-11-03 16:04:19, 00001: Session(0x68140001): Resolved hostname to 167.xxx.xxx.xxx:22
... ...
2022-11-03 16:04:29, 00001: Session(0x68140001): Transfer(0x68140001): Attempted to transfer 2 files.
2022-11-03 16:04:29, 00001: Session(0x68140001): Transfer(0x68140001): Transferred 2 files successfully.
Note: I am using the same account in both the below scenarios,
- Executing SecureFX command from bat file --> Works fine without any issues
- Executing SecureFX command inside SSIS Script task --> Strucks in-between. But when SSIS process is closed, it again does the transfer.
Could you please help me in resolving this issue? Not sure why the SecureFX transfer process strucks in-between when executed from SSIS.
