DSXchange

So, do we still have an actual problem to solve here? Hard to tell after all of the tangential questions. :? If you have checked that you've passed in the correct job parameter, are using it correctly in the Hashed File stage and the hashed file does actually exist at the fully qualified path with a...

No, it can't be matching for any 'new' codes and it makes absolutely no sense to check for a "not equal" condition in a process that only does an equi-join. Hence the suggestion to either check for a NULL back from the lookup (which is what you get when a hashed lookup 'fails') or take adv...

However, it will then read the record, not reject it. You then have to decide what to do (if anything) with the CR/LF in the data.

The 'online' help for that checked option in Sequence jobs fully explains how to fix your problem. So open one, go to Job Properties and click the Help button.

I know they are supposed to be there but I vaguely recall not having much luck getting them to actually work and also something about them being removed...

And yes, FastTrack = v8 only.

Then you need to upgrade.

Unless you are running on a single node, you need both.

But yes, it has been done.

The XML Best Practices Ernie noted is a document that is hosted here at Kim Duke's website. Old but still chock full o' goodness.

:!: Help us out here. Post samples so we know what you are doing and attempting to do - XPath Expressions, Key, expected and actual output, settings in the stage, etc etc. The trigger column is used to spool output to a new file every time it changes, that doesn't sound like something you need here....

In other words, it's more about quality than quantity. The lack of the latter isn't a problem while the lack of the former certainly can be.

Figured I'd start with sorted and go from there.

Cool, thanks for that.

Nooooo... not yet. :wink: Just be a little more careful about the type of questions that you post here, please. Make sure you've researched your question and attempted to answer it yourself, either by searching here or by googling around which can answer more questions than you might think. We hones...

Relocated... and as noted, not really appropriate for a post as it should be handled via email.