DSXchange

What part do you need help with? I don't see anything that looks like a specific question.

Unless you got the exact same error calling the exact same web service, I'd suggest you start your own post and give us the gory details of your error.

OK, I lied.

Since you seem to have full control over the fate of the target column and since it's a varchar why not make it big enough so there's no problem with any of the source data fitting? For example, VARCHAR2(100 Char) or some such...

I set the type in Oracle to varchar2(65 CHAR) and still get the errors. Any thoughts? First thought - please don't send email to us for help, if and when people have something more to add to an issue, don't worry - they will. I don't have any additional thoughts on the 65/67 issue at the moment. Th...

On Windows, that would be by leveraging the move command. And this illustrates how to get help on a specific DOS command which you get to by telling Windows you want to Run cmd : C:\Users\Craig>move /? Moves files and renames files and directories. To move one or more files: MOVE [/Y | /-Y] [drive:]...

Show us some of your incoming data and your null handling syntax.

How can I restrict "Before SQL" not to be executed if there is no input rows to be inserted to the target table? Sorry, only have time for the short answer - you can't. You'll need another approach if it needs to be conditional. One answer might be to only run the job when you know you ha...

So now you are basically just playing 'Chicken' with the size of the target string which I'm wagering is in bytes in Oracle. You've accomodated for one multi-byte character, however should another show up you'll be back to square one. Still would like you to confirm Byte v. Char in your target column.

I didn't recall any such version either but wasn't certain enough to call that out. And from what I remember, you'd have to go back to 5.x for an upgrade to a modern version to be a two step process...

It's looking for the record delimiter, not a field delimiter. How is that defined in your stage? It would seem your ten row sample is structured differently from the full file.

Confirm for us the "semantics" of that column in Oracle - is your target column CHAR(65 Byte) or CHAR(65 Char)? It needs to be the latter for this to stand any chance of working. If you are not sure, check with your DBA.

I did not understand this..From the EndLoopActivity it allows only Unconditional trigger and right now I have it back to the Start Loop..If I add another one here it will send an email for every iteration where as I want only for the last one This is not correct. Yes, it will automatically link bac...

I would just have the 'file not found' processing come directly after the End Loop stage, that way when it exits normally you'll know it ran out of iterations.

EReplace does exist now for PX jobs but you'll have to upgrade to 9.1 for that, from what I recall.

James, Eric, Tony... somebody inferred it up there somewhere.