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

The Net::SSH documentation covers this topic in the FAQ section. Please read the documentation.

"Note: Since i am using Windows platform i can't use Net::SSH::Perl or Net::SSH::W32Perl modules."

If your issue is that you do not have a compiler, the README for Net::SSH::W32Perl states:

"NOTE: I've made ppms (binaries) available for this and most of it's required modules at Http://www.soulcage.net/ppds/. The following command should install everything you need.
ppm install --location=http://www.soulcage.net/ppds Net::SSH::W32Perl"

Or you may want to look at Camelpack, a "Windows installer to setup a complete Perl development environment including support for building C/C++ extensions."

Martin