up vote 0 down vote favorite
share [g+] share [fb]

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:

  1. Which OpenSSH software is most suitable as OpenSSH client (on Windows Server 2008 R2 64 bits)?
  2. 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....
link|improve this question
belongs on superuser I think. – x0n Nov 24 '11 at 18:48
You would have a better audience in SuperUser. – JPBlanc Nov 25 '11 at 4:55
feedback

migrated from stackoverflow.com Nov 25 '11 at 5:02

This question came from our site for professional and enthusiast programmers.

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
or
required, but never shown
discard

Browse other questions tagged or ask your own question.