Before I ask the questions, I have to provide some context information...
I have a SSIS server which invokes a SSIS package. The SSIS package copies a file to a file server. After the copy action, the SSIS package must invoke a SFTP transfer to SFTP copy the file from the file server to another fileserver.
In schema: SSIS Server -> File Server 1 (SSH) -> File Server 2 (SSH)
File Server 1 has the role of a SSH Client and File Server 2 as SSH Server. SSIS Server and File Server 1 are inbound (on premise) and File Server 2 outbound (off-premise).
The SSH must be OpenSSH, all servers being Windows Server 2008 R2 64 bit.
Now the questions are:
- Which OpenSSH software is most suitable as OpenSSH client (on Windows Server 2008 R2 64 bits)?
- Closely related to point 1: how can the OpenSSH file transfer invocation be done remotely from the SSIS server ?
Regarding point 2: There are thoughts of using PowerShell to invoke the transfer....