DSXchange

Basically the sharp signs are not required in expressions but are required pretty much anywhere else (for example anywhere a parameter can be used in a field in a stage editor).

Whether or not you have the role IIS admin, not DS admin, was my question.

Use a RawToString() conversion.

How are you calling the job from the sequence? What's different? I must assume that you are using a job parameter to provide at least the directory portion of the file's pathname; you need to verify (by inspecting the logs of the sequence and of the job) whether or not that parameter value is being ...

Yes, I thought I'd answered this question already.

Mirabile dictu, I came up with the same answer!

Create a VarChar column derived as Start:End and another derived as End:Start. Use these to effect your comparisons and duplicate removal.

It would be interesting to see the %CPU for these operators.

Who?

Fact table, definitely. I like to have the measure of things.

Your proof of this assertion?

The second backslash after "ftp:" seems to have gone missing.

Try it with three or four backslashes, or try it with forward slashes throughout the pathname (Windows understands forward slashes).

Should be OK. Try it.

Every link in the (parallel) job design has a (virtual) Data Set associated with it. The Sequential File stage reads the file and imports in into the virtual Data Set in memory, which the Standardize stage can use as its source. A similar story is told on the output side, except that the operation i...

Create one column derived as Start:End and another derived as End:Start and use these to identify your duplicates.

You can perform these "blocking operations" in server jobs, but not in single parallel jobs. But even there persistent storage is involved.