DSXchange

Find the log entry in the Sequence job's log for the Execute Command stage and double-click on it. Post the contents.

I specified "dot log" and "file" to mean Oracle's sqlldr log file, if you don't see one then it does sound like you could have a path problem, something else that a wrapper script would solve for you.

Try fully pathing the sqlldr command.

I've deleted your duplicate post on this topic, there's no need to post the exact same issue under a slightly different topic. If you need to clarify something, please do so in the original post by replying to it or editing it. For grins, I'll paste the other contents here even though they are virtu...

That's another artifact of your original issue, the non-zero exit code which is also being reported by the "Automatically handle" option you've enabled in the Sequence job. An exact search here for "Controler problem: Unhandled failure" will reveal that. So... you need to actuall...

Why can't you simple read this as a pipe-delimited file? What exactly happens when you try? I'd also be curious why your Field() function is failing you, what exactly happens when you ask for the 5th field? :? At some point you'll probably also need to clarify what the 4th field has to do with this,...

Saha - I've moved your post to a more appropriate forum but had to guess on the particulars. Please let me know if you are using a Server job for this rather than a PX one. If the version and O/S choices I made were wrong, please edit your post and correct them. Thanks.

OK, fair enough. People typically do this from within a script where you have control over all aspects of the call. For example, my sqlldr "wrapper" script sets up all of the environment variables needed and double-checks the actual output of the loader log to ensure no errors occurred. Al...

Then the first suggestion would be to actually search the forums here. You're not the first person to see this error and it has been asked and answered so many times here that it should be easy enough to find. In other words, an exact search for "[ParamValue/Limitvalue is not appropriate]"...

ArndW wrote:This is confusing - the cut-and-pasted text is from a windows installation.

I know... why not post the actual error rather than crib one from someone else's post?

Actually, it did not "work fine" from the command line, it's just that there was nothing there to report on the exit status code. As noted, a command that does not return a status code of "0" is considered to have failed in some fashion by anything that actually checks. Your scri...

Don't know about anyone else, but I answered the way that I did because the question was how to "send rowcount as email" specifically sending them in the email body - not how to get the counts to send.

Post the complete, unedited error message.

What UNIX?

If you can get the information you want to send into a file then you can send it out in an email as an attachment but there's nothing "out of the box" to get any kind of variable text into the body of an email. To do that, you would have to write your own emailing routine, one that either ...

Best if you can get an xsd from whomever produced that file and import the metadata from that, but worst case you can use the XML as noted. Hopefully it is a complete representation of what your files will look like in the long run.