DSXchange

"Better" than the orignal method as it is easier to understand, simple to setup, is all in DataStage and actually works as an added bonus.

All this IMHO, of course.

Data is skewed? Example, please. Is your problem just with the "123 Main St" field with the extra comma?

No, what is posted in an "upcaret-oh" as in "^" followed by the letter O... note the difference in the zeroes posted next to them. And also note this is one character not two.

My assumption was "it is ok" should really have been "is it ok?".

So... you're saying a dataset created on two nodes can be read under a four node configuration? Interesting... honestly didn't think that would work.

No.

True... but the alleged issue is the fact that it isn't even in the repository, so technically there would be nothing to add to the palette.

Ugh. You should have just said 'no' - this really needs to be done either by or under the direction of a very knowledgeable support person.

Convert the date to a string in the same format, then you can compare. Or convert your string to a date first.

The job must abort in order for any rollback to happen. Transaction Grouping is not the correct approach for this situation as it commits each 'group' of records as they are processed so individual groups can be rolled back on a failure..

Technically, 'move' is for moving a file from one drive letter / location to another and 'rename' just renames a file in place. With a UNIX background you might gravitate to 'move' but 'rename' would be more appropriate even if the other can be made to work.

First off, you need to do it after job not after stage. Secondly, you need a valid DOS command for the task - use rename rather than move. Get it working from a cmd prompt then add it to the job.

Did you specifically check in StageTypes \ Parallel \ Database?

Please post your 'new' XPath Expressions and a sample of the edited input XML, please.

A much better solution would be to build a Sequence job with the Start/End Loop stages. Pass in the $Counter variable as a job parameter to use in your output filename. IMHO.