I need to automate this in and agent job. I have used script task to sftp file from window to Linux and vice versa. However, I am not permitted to push files from our SQL Server so I need to place the files on a Linux files server in house and then push them to a vendor. Thanks in advance for any advice.
