DSXchange

Tony has inferred above that the "t" stands for "Torrent".

That "null field value" specifies the value that, if found in your source data, should be considered a null and will be transformed to one in the process. And no, you cannot specify multiple values there so any other values you need to check for must be explicitly done "in job".

To me this is an "apples and oranges" comparison and something that would benefit greatly from PDO usage.

Neither am I, hence my response.

If-Then-Else.

:idea: I've split you out to your own post. Now that you have your own topic, please (as Ray notes) start at the beginning rather than search out something unrelated you think might be your issue. Since you've never posted here before, tell us about your environment, version, etc and the details of ...

I'm not saying to do "the same thing" at all as there's no need to issue the stop request. What stage(s) come after the End Loop stage? Meaning when the loop ends do you do anything else? All you need is a Sequencer set to 'Any' after the End Loop to branch to which will end the loop early...

Probably the fact that 'after job' the job hasn't actually ended yet. It's still running until everything After Job finishes.

To be honest, I can't say that I've confirmed this personally through actual experimentation and observance. I'd just be shocked as hell if it doesn't work that way.

Since it is checking the system time: Yes. Yes.

Sounds like a permissions issue to me on the files in your Project directory. What umask are you using? What are the permissions on the DS_STAGETYPES hashed file, for example?

The value being discussed is not declared as a job parameter, they just want to bring it in from the environment - hence my advice.

You can't use it in an "ini" file like that, it's just text there nor can you use it as you've shown. If you want the "project default" value just read it from the environment: GetEnvironment(My_DB) is one way.

That should be... fine. I would typically check the time and branch past the End Loop to get out early, that way is more 'graceful' as the job ends normally and you can still do whatever wrap-up / completion steps you may need.

You modified the ExecSH routine? Not a good idea unless you gave this version a new name as well.