DSXchange

OK... so... where we at with this? "Working" or "Not Working"? I'm not sure any more. Or it is running on two nodes but you don't see that in the Monitor?

You don't even need the ">0" part.

ps. In no way take this as an endorsement of what was posted, just making a point regarding syntax.

That's not "free form" that's proper "xml form"... one big string. I'd be curious what Ernie thinks when he gets a chance to drop by but any process that requires specific XML formatting to work is a poorly designed one. IMHO, of course. Yes, you can go all Old Skool and do all t...

The only argument that should be quoted is the delimiter to be used.

Why? Formatting is for peoples, no process you create this for will care. And you can always "pretty print" it yourself afterwards simply (one way) by opening it in something like IE. That's how the formatted output option in the stage works and looks - "turn it off" is my best a...

I'm hesitant to comment on any such behaviour in the 8.0.x release as it was buggy as heck and there are so many patches and fixpacks you may or may not have installed. May I humbly suggest you upgrade ASAP to the latest 8.1.x release? You'll be much happier.

Have you used the Aggregator before? It has... rules. And quirks. Do you understand what is meant by an "implicit" conversion versus an "explicit" one? Have you searched the forum for key bits of your message? It has all been discussed here in the past. Not sure where to start wi...

Substring, conversion, math, conversion, concatenation. Probably in a Transformer with stage variables.

So... did you read Ernie's post and follow any of his advice? There's a lot to learn to do XML successfully and it's not something we can teach anyone in a post or two here. You need to put some effort in on your part and then we can help when you have specific questions or there are problems with t...

So, no warnings but a fatal instead. OK, so that's not an option, and it seems my "understanding" was based on bad information.

Have you checked with your official support provider, asked them?

And now, are you getting what you need? Care to share your "workaround"?

IBIWISI... new forums, that is.

Pffftttt... silly wabbit.

SQL Statements, plural? Do you have two lookup stages? :? Have you run the job through the debugger to see what happens? The Server product actually has a pretty nice one, something the [cough] other one doesn't. Or at least didn't the last time I was using it. Just becase you have "millions of...

Kind of like "spits the dummy"?