question

rahulmehta08 avatar image
rahulmehta08 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?
ssisftpfile-systemsftp
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Magnus Ahlkvist avatar image
Magnus Ahlkvist answered
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).
5 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Yes, you can use Project (or package) parameters and build a string for the Arguments setting in the Execute Process Task.
1 Like 1 ·
Correct me please which will be more efficient way pscp or pftp for moving files from windows to linux.
0 Likes 0 ·
to solve the fingerprint dilema, I use echo to pass in an answer when dealing with a known sftp server... echo n | .\psftp.exe "y" might be the better answer from a security perspective. in that case, you only need to pipe it in for the first execution
0 Likes 0 ·
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.
0 Likes 0 ·
Thank you Magnus and kenj..I have one more question can we make the directory name and server path parameterized
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.