help with making an sftp connection

Hi,
I'm not a perl coder, (though have written a few very simple Perl scripts when necessary) but now I need to write a Perl script to transfer specified files from one computer to another. I have scribbled out a script a while back using FTP, but now need to use SFTP. I can re-use most of the old FTP code/logic, but need some help to make the actual connection.

It is a secure (no external connectivity) network, with no public/private key security available, so authentication just via user/password

Some Googling for how I might do this in Perl has thrown up several possibilities, more confusing than informative, so I'm not sure how to best do this.
It looks like Net::SFTP::Foreign might best fit my needs, but I'm open to suggestions.

Advice or a code snippet on how to make the connection should be enough, and much appreciated!!


Thanks,
Brent Wood