DSXchange

We will be getting BASE64 encoded data embedded in a file that needs to be decoded and stored in a blob. There is a base64 decoder in XMLPACK but the data we will be getting is not XML. Is there a BASE64 decoder hidden among the built-in transforms? I have not found it. Will I have to write a custom transform for this?

Since DataStage can't handle BLOBs, you're seeking an approach that DataStage won't be able to implement.

Transmit the BASE64-encoded text string unchanged, and decode it after DataStage has pushed it through. Or don't process it with DataStage at all; just use operating system facilities (copy, remote copy, ftp, etc.).