DSXchange

I'm assuming this advice is valid here as well: search the forums for information on the GetEnvironment() function and try using that.

A Sequence (no 'r') job can pass a parameter defined in it to both jobs. Do you mean pass a value created in one job to another? If so, one way would be via USERSTATUS, search the forums here for the 'how'. Another way would be to land it and have a RoutineActivity or ExecuteCommand stage pick up th...

Haven't heard this before. Which 8.x version are you running?

Yes, I too would prefer using "ls -m" here. And you wouldn't need to do anything special in the UserVariables stage other than fetch the list of all files, the StartLoop will (when set up properly) automatically iterate through the list and can pass in both one item from the list (in your ...

And please learn that there's no need to explicitly set the output for a Boolean. All you need is "trans.empno=mast.empno" for the derivation, that "if-then-else" construct (while it does 'work') is completely unnecessary.

This is a common problem for anyone creating 'Excel' files which a search here or a quick Google would turn up... and one not easily solved. Without a pre-formatted target and the GUI, Excel will always convert anything that looks like a number to a number during an import and remove any non-signifi...

Ah... this has been discussed here before. So, I assume you enabled the RTLogging option, yes? Did you also end up running the mentioned script to create the auto-purge task?

To expand on the transforms answer, since they can't be called you need to open up the transform and use the same code it uses directly in your code. As for testing BASIC code, I do a couple of things. One is the typical 'test' routine where I either build up the routine slowly, piece by piece, or j...

Ah... true. You need to use dsdesign.exe to get that HTML report, check this post for an example from Kim:

viewtopic.php?t=124036

'Set' in that case would mean create them in the Administrator. Not sure what their value should be, however.

Curious why you wouldn't use the Surrogate Key stage for something like this, seeing as how it does all that automagically?

I'm wondering why you would need a routine when the stage will (allegedly) handle this for you... are people finding that not to be the case?

Where are you doing this? In the 'current job' (which is what DSJ.ME is a handle for) you don't need to 'get' any job parameter, simply reference it by name, possibly surrounded by hash/pound signs: #RootFilePath#. This is also how one would pass a job parameter to a routine.

Did you read Ernie's blog entry?

I'd also be curious what exact 7.x version you have and what UNIX platform you are on.