You are right, and I appreciate all your help. I just answering why I did not try this last thing htat the person asked me. I have tried a few things and I have not gotten a lot of error messages. For example, I tried setting up a script with and Proceds task in SSIS for WINSCP as the directions state and when I run it this ssi what it gives:
"[Execute Process Task] Error: In Executing "C:\Program Files (x86)\WinSCP\WinSCP.exe" "-Script = C:\Users\ed.walsh\Desktop\uplaod.txt" at "C:\Program Files (x86)\WinSCP\", The process exit code was "1" while the expected was "0".". And am think you will agree that this really does tell us much. Other times, with other things that I try it gives nothing, just does not move the file. Of course, I am doing something wrong, but I believe that is due to a lack of information on the sites.
Now back to the post, where he asked me what was wrong with this I can see already I had a lot of questions in it that I, so can you blame me for not wanting to set yet another thing up that is not clear.
Unfortunately, I cannot show the script because that has company information in it (below I have it with fake information), but the nice thing about winSCP is that it generates the script for you based on you information. and I can tell you that is matches what the documentation shows. So I do not know.
But I did not mean to offend anyone I was just explaining whey I would not jump and use that solution.
My script:
# Connect to SFTP server using a password
open sftp://User:Pass@company.com/ -hostkey="ssh-dss 5555 XXXXXXXXXXXXXXXXXXXXXXXXXXXXX=" -rawsettings FSProtocol=2
# Upload file
put C:\Users\test\Desktop\testUpload.txt /home/user/
# Exit WinSCP
exit