in reply to log_file in NET::SFTP?

How do I capture my session messages in the NET::SFTP script?

Net::SFTP does not offer such feature but you can use something like Aspect to perform some action every time the operations you want to log are called.