ssh connection manager has no vartiable/expression for passphrase

[tm...@chevron.com]

I am trying to use sftp and use a keyfile/passphrase for my
connection. On ssh connection manager I have tried populating
serverpassword with an expression. It appears conenction manager is
not using this variable because I keep getting Auth cancel
(Tamir.SharpSSH).

I am able to test the connection in the foreground successfully. What
am I missing? Is there a variable for passphrase in ssh connection
manager? I'm using 1.2

Thanks in advance for any help.

[Ivan Peev]

Hi Tim,

The evalutation of connection manager expression is a little bit
tricky. The way Microsoft designed it is to evaluate expression after
a client of the connection manager calls '<Connection
Manager>.AcquireConnection' method. I'm not sure what is the exact
setup of what you are trying to accomplish, but if you send me a
sample SSIS package, I may better able to help you.

When 'ServerKeyFile' property is not empty, the connection manager is
working in authentication with key file mode. The 'ServerPassword'
property must contain the key file pass-phrase value.

Regards,
Ivan