Shawn Melton (4/16/2014)
If the vendor also offers secure FTP you could use SSIS to do this but would require a third party add-on or script since SSIS FTP task does not support security FTP. The other option might be sending this to a web service through an XML format, there is a task in SSIS for doing this.
The vendor really really really wants me to use HTTPS and is pushing back on SFTP as a last resort.
Webservice, huh...
I did find this link to C# code (code at the bottom) that I might put in a script task, but I don't see a line where it's actually pushing a file. Just connecting. Though, I'm wondering if I could throw some sort of Stream writer (C# novice here) that would do the trick.