sftp is made for interactive sessions. To overcome the password prompt, your target server must support key based authentication. Once you have your keys set up, you can use sftp in batch mode (-b), or at least login without a prompt.
Ok, so it seems like a good approach for me is to use the EXPECT functionality. To do this I need TCL and Expect installed? If so, how can I verify I have this installed?
Also, just so I understand. My ksh script will call another script which is my expect script and does what I need it to do right? To invoke it I need to add to the top line # /usr/bin/expect or where ever expect is installed??