I am using following command
rsync -avze ssh myUser@REMOTE_SERVER:/REMOTE_PATH/ LOCAL_PATH
It's asking for password. Is it possible to pass password through any script? I do not want to use ssh keys.
You have tagged your question with perl so...
Use Net::OpenSSH:
#!/usr/bin/perl
use strict;
use Net::OpenSSH;
my $ssh = Net::OpenSSH->new(user => $user, password => $password);
$ssh->rsync_get({verbose => 1}, $remote_directory, $local_directory)
or die $ssh->error;
I think that sshpass will do what you need:
https://www.cyberciti.biz/faq/noninteractive-shell-script-ssh-password-provider/