What Linux distribution are you using?

Let's break up your script.

Code:

#!/bin/bash -x

Code:

sftp -oIdentityFile=~/.ssh/id_rsa/sftp -v username@192.168.17.181<<EOF

The above statement worked fine.

Code:

cd ../../

are you trying to change directory in your local machine or your remote machine?
if you are changing in remote "cd" will work.
if you are trying to change locally, try "lcd"

Code:

put ftpusers/TransferFolder/ftp/data/*

try using absolute path starting from "/" example "/home/user/ftpusers/TransferFolder/ftp/data/*"

Code:

echo "File transfer has been completed"

echo will not work inside FTP, need to use after EOF.

Code:

bye
EOF

This looks good

Also please see below a version of script that worked for me.

Code:

#!/bin/bash -x
sftp -o IdentityFile=~/.ssh/sftp -v remote_user@remote_machine<<EOF
cd files
put /home/localuser/files/*
bye
EOF
[[ ${?} -eq 0 ]] && { echo "File transfer has been completed"; } || { echo "File transfer Failed"; }

The above script transfers all the files from dir "/home/localuser/files/" on the local machine to
"/home/remote_user/files" directory on the remote machine.

hope this helps.

Moderator's Comments:

Please use CODE (not HTML) tags as required by forum rules!