Hello, my name is Michael. I can help you with your question. You can use FTP from the SSIS package.
Drag the FTP Task component on the designer window
Now double click on the component. This will open the FTP Task Editor.
Using this window, one can establish a new FTP connection manager; configure the task for a specific FTP operation (such as Send Files, Receive Files etc.) and also add any expression to change the behavior of the task execution.
Alternatively, you can use the command line FTP client with an FTP script to upload to the site you need. For example, a simple FTP script would just include the FTP commands like this:
open 188.8.131.52userguestguestput file1quit
That would be saved into the .scr file, then you can run the script like this:
Let me know if you still have questions. I will help until your question is completely answered.
SFTP is quite a different story. Sorry, but you had not mentioned that in your original question. In order to automate this, you will need "passwordless" authentication - authentication using a key only. Are you able to get that set up on the server side?