I'm looking to automate a process that will occur daily.
I receive a CSV file to a unix SFTP server once per day. I want to send the file contents (from the server) to an e-mail address (Exchange server) in order to be archived to Symantec Enterprise Vault.
I was thinking of using a mail API of sorts, but I'm having trouble figuring out where to start. How will the script grab the file from the UNIX SFTP server, and then send to the address?