SSIS Execute Process task with Password including @
I am trying to connect to SFTP using execute process task with inputstandardvariable as a variable which has a command
option batch on
option confirm off
open sftp://Username:Password@123@sftp.compassphs.com
lcd \\network\Temp\
option transfer automatic
get /home/Test/*.txt
exit
This command works absolutely fine,but if there is an '@' in the password,i am not able to get the files,the package fails.Could you please tell ma workaround.
Thanks
Rama
option batch on
option confirm off
open sftp://Username:Password@123@sftp.compassphs.com
lcd \\network\Temp\
option transfer automatic
get /home/Test/*.txt
exit
This command works absolutely fine,but if there is an '@' in the password,i am not able to get the files,the package fails.Could you please tell ma workaround.
Thanks
Rama