asked
Can we use psftp (i.e putty sftp.exe) for moving files from windows to linux based system from ssis
Can we use psftp (i.e putty sftp.exe) for moving files from windows to linux based system? i know pscp can used to do the same.But can we do the same from psftp?
I imagine the problem with psftp would be the same as when using pscp: When you deploy your SSIS package, where you use an Execute Process task, your package will run under a certain user context, which will differ from your own user context. Therefore, psftp would want to store the fingerprint for the sftp Connection in the Windows profile of the executing user context. Doing that is an answer to a prompt from the psftp command and you wouldn't be able to answer such prompt from an SSIS package. I guess you could run psftp manually, under the user context of the Proxy account used for your SSIS package, answer the prompt and then deploy your package (the prompt to save the fingerprint only shows up first time for a new Connection).
Yes, you can use Project (or package) parameters and build a string for the Arguments setting in the Execute Process Task.
Correct me please which will be more efficient way pscp or pftp for moving files from windows to linux.
This is a bit outside of my comfort zone, but I think pscp could be faster because the protocol for scp doesn't require waiting for packet acknowledgements before sending the next packet. There are other differences, like scp not being able to interrupt a transfer.
Thank you Magnus and kenj..I have one more question can we make the directory name and server path parameterized
17 People are following this question.
