Brandie Tarvin (4/16/2014)
The part I keep getting hung up on is the "automated program" part of the document. What program should I be using and is there a way for me to do it using the SQL Server tools I have access to?
I would probably opt to figure out scripting the upload of a file using PowerShell. You can then simply set this up as a step in a SQL Agent job. I have used it playing with downloading files but not uploading. I found this that shows the class you would use is WebClient.UploadFile.
You would also have to test to see if this supports using HTTPS, which I think it would.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton