SFTP script and password prompt

I am trying to create a script which will eventually SFTP a file but I'd like to have it where the operator MUST enter the password to login. The script would make the ftp connection, supply the userid, then prompt for the password while the script is running. Is that possible?

Ooops... Make that a WinScp.exe script.

Just do not provide password in the script. That's all.