Another option is the psftp program, part of the PuTTY set of utilities.

It accepts the user and passwords as arguments on the command line, though this is not very secure as other users would be able to see then just running ps.