login about faq

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?

asked Jun 25 '14 at 00:34

kipper007's gravatar image

kipper007
1112

edited Jun 25 '14 at 00:39

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.

(Jun 25 '14 at 01:15) Martin Dobsik ♦ Martin%20Dobsik's gravatar image

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.

(Jun 25 '14 at 01:18) Martin Dobsik ♦ Martin%20Dobsik's gravatar image

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.

(Jun 25 '14 at 01:23) kipper007 kipper007's gravatar image

I should add as well, I have a public key.

(Jun 25 '14 at 01:25) kipper007 kipper007's gravatar image

Well just run something similar you do with scpg3. e.g. sshg3 -v <your_remote_user>@<your_remote_server> echo foo

(Jun 25 '14 at 11:33) Martin Dobsik ♦ Martin%20Dobsik's gravatar image
Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or __italic__
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×17
×1

Asked: Jun 25 '14 at 00:34

Seen: 53,689 times

Last updated: Jun 25 '14 at 11:33

All user contributed content licensed under the cc-by-sa license.
Powered by OSQA.