DSXchange

What have you tried? Substringing every five characters and concatenating your 'special character' between the pieces?

You don't need a stage to tell you that, the job can. Use DSGetLinkInfo() to capture the number of records sent to the stage. And you'll need to upgrade to 8.x to have any control over the Transaction Level AFAIK.

Unless you are asking about a QualityStage job, this is the wrong forum for this question.

Four processes = four nodes.

You unconditionally reset every job after it has run? If so, then the status will always be 'Has Been Reset'.

Maybe.

For the 'execute' part... DSExecute().

Not just 'yes' but that's exactly and all that that stage does - run operating system commands.

Try it. Force whatever condition you need to log an 'alert' for.

Wrong forum. However...

Yes.

It adds 'executables' to the export so that you don't need to compile post import.

Any stage that involves SQL. Specifically here, that would be the database stage that the Lookup stage (set to Sparse) leverages.

Right, but he did specify that it was a string so I didn't bring that up.

OK. How will you identify the unwanted records? Rather than put them in a lookup, why not simply use that as the source and delete them directly?

First you need to decide if you just want to delete the "unwanted" data or rebuild the table with just the data you want. I'm guessing "rebuild" from your truncate question but I don't like guessing.

The "L" option gives you the ability to specify the character to trim.

Have you looked into the Trim function? Specifically with the "L" option?