SSIS and WinSCP
I have my script running perfectly from command prompt
option batch continue
option confirm off
open mysession -hostkey="ssh-rsa blah blah"
open sftp://usename:passward@xyz.com
get /outgoing/*.txt c:\test\
exit
It works fine from command promt but when I run it through execute process task in ssis , it prompts me for user name and passward and says that 'access denied"
Can any one help me with this?
Thanks in advance.sdsd
November 10th, 2010 5:48pm
Do you run BIDS as an admin?
If not run as admin and re-test.Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
November 10th, 2010 11:48pm