DSXchange

StringToDate() with the appropriate format string, I would assume.

I'm hoping your SQL example is just a test as you certainly don't need SQL or a database to get that string into MON-YY format.

Try putting each single quote inside a pair of single quotes, i.e. each one becomes three.

Which is more about the settings you are using in the stage rather than the choice of stage. Can you detail those, please?

Or maybe Ernie already has enough information here to help. Me, I'm just trying to set the table, he's the one that bats cleanup here.

XML is XML so that choice of stage shouldn't really matter.

Generally, regardless of stage, 'real time' in this context would mean publishing your job as an 'always on' job, a web service. You might get more information by taking a look through the SOA Editions forum here. I would be curious about what kind of volume you'll need to be processing.

Can you expand a wee bit on your question, please?

No constraint. There should only be one record per account post-aggregation. Take min or max on your status, whichever is needed to get your desired survivor. Actual examples might help if you still have issues.

A constraint can't solve your problem seeing as how multiple records are involved. How about trying to use an aggregator?

You've lost me but any time I see "sometimes works, sometimes doesn't" complaint I have to ask - does it "always work" if you run it on a single node?

Okie dokie... let us know where this goes next.

That's a "3" actually, isn't it?

I don't work with this stage so not sure how much help I can be but... let's start by clarifying what you mean by "read multiple spreadsheet" and "single spreadsheet excel". Are you talking about reading multiple files or a single spreadsheet file and you need data from multiple ...

That doesn't sound like your issue, that looks to be specific to parameter values with <CR><LF> characters in them. Probably best to open your own support case and let us know what you find out.

They're all listed in the various "header" and/or "include" files that ship with the product, perhaps even in the documentation somewhere. I don't recall seeing a "4" in the past but you could take a look at this post and see what your versions of the files noted in it ...