Can anyone tell me how to supply password using DSA or RSA keys in Net::SSH module.

Note that Net::SSH requires the `ssh` command, so presumably you have cygwin installed and ssh installed in it. Then, as the manual says, use ssh-keygen. You can find plenty of tutorials describing how to do passwordless logins. Basically you'll append id_rsa.pub or id_dsa.pub (your public key) onto the remote system's .ssh/authorized_keys file (if you have ssh-copy-id, it's even easier).

I'm not sure why you say Net::SSH::Perl or Net::SSH::W32Perl won't work because you're on Windows, though.