DSXchange

I'd use one of the key management routines from the SDK in a Routine activity and use the value returned to provide that number to other activities.

Well, "why not shared container" as a starter? This is the ultimate re-usable component. Given that you're on such an old version and using server edition to boot, you don't have many options apart from File > Save As to make clones of a job design and modify the clones. As you get into ve...

After capturing the rejected rows from the Sequential File stage using a reject link, re-parse them for example using a Column Import stage or Transformer stage.

To put it another way, machines don't have nodes.

Ordinarily the entry for the field definition would be in the file dictionary rather than the VOC file. If you want to use SQL to change the record, then you will also need a VOC entry for the hashed file itself.

I believe that is the default default.

Best practice is to remedy that immediately the project is created, since you have the Administrator client open anyway.

That does not address the issue, which is the lack of metadata in the hashed file's file dictionary.

Bad advice, impossible to implement. Why? Read my earlier post again.

IA analyses use DataStage (in ANALYZEPROJECT) to process the source data. Presumably this project is on the engine tier machine that is not available. Solution: wait till it becomes available.

A second output, perhaps?

"%yyyy-%mm-%dd" does not match 20101015. You need to get that right first.

Routine activity. Pass the job status as a routine argument.

Execute Command activity. Pass the job status as a command argument.

It's just as easy if the order has to be 1-2-3-4. Build sub-sequences for 2 and 4 that determine if it's their day to run and only run them if it is. (You could, indeed, do this in the one sequence, with multiple paths and Sequencers.)

The project default is always set, even if the setting is "not enabled".

If it's changed, the changes only affect jobs created/imported after the change has been wrought.