DSXchange

I found it in the Server guide and it says:

"EventType is the type of event logged and is one of:"

And then it lists all of the types. If you want multiple types, it seems to me you'd need to do so one at a time or use the "any" option and filter out the types you want.

Is this question truly about Server jobs as the post is marked?

You've said it works fine if the job fails and that "do loop" only runs when the job status isn't 1 or 2, so it doesn't seem like that could be the culprit. Are you sure that you noted when it fails correctly?

:D

Your input stream is split ('forked') to allow one side to be manipulated in a different manner from the other side... and then these two streams are joined back together. Typical usage could be where you need to count a group of somethings and then make a decision for each group member based on the...

You should still be able to use an Aggregator for this by telling it to 'retain data type'... or something very close to that.

This is.

Sure, set the Read Method to 'File Pattern' and then supply the appropriate wildcard pattern to read the file. Yours could be "FileName_*.txt".

I don't see the point, furthermore it seems to me that unless you change the Sort stage to "Don't Sort", it will happen twice.

Error messages in the log can only be retrieved from the log itself.

There's no conversion of any kind here, they just need a simple check for all zeroes so those rows can be filtered out. Stage variable svIsValid:
Use svIsValid as your constraint.

Hand this over to someone who does have the rights. In dev.

First step is always identification - you can't replace it if you don't know what it is. And by that I mean the decimal value of that particular ASCII character. Once you know that, you can use Convert() with the CHAR() function to remove or replace them.

Seems to be a reserved word, can you rename the column to something like XXXX_TYPE?

no there is no problem with the path. i copy the command generated by sequence from log and run on shell and it gives output. FYI - this doesn't really prove anything, you could still have a path issue in the job. The only way to avoid that is to use an absolute path in the stage. To me it seems li...