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:
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.