Hi, I am using SSIS to automate a file transfer. For some reason when I run the process in debug, everything works fine. I am also logged in using the service agent. I wanted to post the batch file code, but when I do my question is not displayed? When I run the package through the job agent, I get the following error: The process exit code was 10, while the expected was 0. Can anyone help me? |
You can enter verbatim text by preceding each line with 4 spaces. That should help. There is also strange filter. If a text contains something that looks like URL, the whole text will not be displayed. in that case you need to escape the dots that make something look like URL. Eg. text ssh.com (I have escaped "." with backslash so that you could see it). The links (URLs) need to be inserted using the UI link button.
The important issue here may be the user account under which the scpg3 command is running. What is it? Also you get better troubleshooting messages if you can reproduce the same problem with sshg3 client. If so try the "-v" option of sshg3. It behaves much better than with scpg3. Gives more error information. Store the stdout and stderr to file and see what is there.
Thank you Martin.
I am really new to this, so could you please provide an example of the sshg3 client using -v?
The account is the same account I am logged in with. It is a service account that runs the sql job agent.
I should add as well, I have a public key.
Well just run something similar you do with scpg3. e.g. sshg3 -v <your_remote_user>@<your_remote_server> echo foo