SSIS Execute Process task with Password including @

Advertisement

rama
Joined:
Posts:
1

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

Reply with quote

Advertisement

You can post new topics in this forum