DSXchange

"All the job"? Every single job in your inventory looks like your example and fails with the exact same error message?

Sure - simply "Add to Schedule" every six hours for the days / time ranges you need.

The other important question is - is the stage generating sql for you or are you using custom sql? Generated sql will use a TO_DATE() and expect your data in YYYY-MM-DD HH24:MI:SS format, which is by far the best way to go.

Both the before/after ExecSH commands and the Execute Command stage can execute operating system commands directly as well as scripts.

LRM is a sqlldr specific error and, as Ray noted, the solution is to correct your syntax so it doesn't think you are sending multiple values for a parameter: Cause: An attempt was made to specify multiple values for a parameter which can take only one value. Action: Do not specify more than one valu...

And you really shouldn't have any issues. Except, perhaps, for the kind where you've taken advantage of a bug and they've closed that loophole.

You really should start a topic of your own and and explain in full what problem you are trying to solve.

ps. Your assertion re: EReplace is incorrect.

I tried entering the command: list_readu | grep $cmbatjbs Ray never meant you to stick a dollar sign in front of either a job name or the pid being looked for. When you tried it without one, is "cmbatjbs" your exact job name, all lower-case? You can add the "-i" option to grep to make it case insen...

Note: In the mean time I'm also getting "Abnormal Termination of stage $jobname: TRN_PASS (transformer stage) detected" Error message. This message occur in all other jobs too. New problem = new thread. Start a new discussion to talk about this and, when you do, please clarify that you do indeed me...

Hmmm... if I'm following... if you want to include an 'XPath Expression' in your output, you will need to manually copy it from whatever Descrption it lives in to the Derivation of the field you want to write it to. There's no way to "read" it from anywhere.

The Description TAB? No such thing. The Description column that holds the XPath Expression for each field? You don't "read" anything from there. The stage "reads" what you put there to know how to parse the field it is associated with. Let's take a step back and start over. What is your job attempti...

Lost.

You still 'transform' a value in the derivation of the field, XML or not. Could you rephrase your question, please? Not really sure what your issue is right now.

Come on, what the heck does this have to do with the current topic? Hint: nothing. Please start your own post on this subject.

Oh no, it broke.

What are you using to access Oracle? ODBC? These kind of 'BCI' messages are not logged by the native OCI stage, hence the question. Aslo note that #1 must be coming from an update or delete and is telling you that it updated or deleted nothing. Only you can know if that is a problem or not with the ...