DSXchange

Handle the nulls properly. An exact search for "Converting a nullable source to a non-nullable result" turned up 37 conversations on the subject.

Arnd - what does the "-C" buy you?

"Maintenance issues"?

viewtopic.php?t=122709

As long as what you are renaming it to does not already exist, unless you are fine with one overwritting the other.

The message "'cannot get exclusive access to executable file" usually means you are trying to compile a running job or the job is being monitored. Not sure about the "resource locator" one, have you tried searching the forums for that phrase?

Search is your friend! Try an Exact Search for "Failed to enumerate Local groups" and see if anything there helps. Could be a couple of different reasons.

Excellent! Glad we were able to bring this to a successful conclusion. :D

My point is, the INSERT statement should never be in the log as the constraint is never satisfied for any row. This is baffling! This is simply not true. The SQL for every link is logged when the stage is initialized / opened regardless if it ever fires or not. Let it baffle you no longer, my son. ...

Or if the length of the target is variable:

And the 'calculated value' will always be a single digit?

Ah... figured it would be something like that, unless 8.x totally changed the game there. Those values are stored in the client PC's registry, so what you did obviously worked but I wonder if you could have just edited the values in question to remove the question marks? Please mark your post as Res...

Sure, you can use 'dsjob' to dump job names to a file and then drive from that file. Or you could actually read DS_JOBS directly with a Hashed File or Universe stage in a Server job to drive this or to populate the file.

That Convert() function is turning the field delimiters inside the string to "Value Marks", magical goodies that make a field "multi-valued" and are key to the normalization that can be done.

If you know the max - create that many additional fields in a Transformer, populate with Field(), pivot and then filter out the null results.

Yours we know. I was asking neeraj.