We are running windows 2008 R2 and sql server 2008 R2. The dtsx file was created in BI2008. It works when running in visual studio now but it failed on two of the uploads last week. I republished to the sql server and it won't run. I just upgraded to winscp 4.3.3 in hopes that that would help , but no go. I have a profile set up in winSCP and saved using the account that sql agent is using to run the job. The FTP server is old and has been used for many years for ftp but I don't have any access to it other than one directory that we upload and download to and from. I am using an Execute Process Task to run the upload/downloads. I tried using a script file but couldn't get it work at all so I am putting the command on the arguments section of the Execute Process task.
Here is the syntax:
/command "option batch on" "option confirm off" "open ""firstname.lastname@example.org""" "put ""C:\Database\major.dat"" ""/xxxxxxx/grad/""" "close" "exit"
The error that is generated is always this:
[Execute Process Task] Error: In Executing "C:\Program Files (x86)\WinSCP\WinSCP.exe" "/command "option batch on" "option confirm off" "open ""email@example.com""" "put "C:\Database\uploadapptest1.txt" "/xxxx/grad/"" "close" "exit"" at "", The process exit code was "1" while the expected was "0".
The process is appending "at" to the end and causing it to fail.
I tried saving the profile with a one word name like "work" but that didn't help. Do I need to escape the @ symbol somehow? We are using public/private keys for authorization. The account used to run the job has permissions to windscp folder, and keys in its own folder and was granted admin on the server, but no go.
Any help would be much appreciated as I am having to manually upload and download the files since we are now in production.