DSXchange

Do you understand what it is doing - i.e. why it worked? I always wonder in situations like this.

Why choose XP, an unsupported operating system?

And when he says 'exclusive' he means exclusive as in not another soul, alive or dead or undead, in the project. Nada.

There is a Locate() but probably not what you are looking for, sounds more like Index() is what you're after. Why not look into the Fmt() function that Ray mentioned?

Typically from the command line using whatever utility exists for that using the Execute Command stage. For example in Oracle: sqlplus. And that usually with a wrapper script rather than a direct call.

For the question of RCP in Server jobs the answer is quite simple - there is no such thing.

It doesn't know that.

What did an exact search for "Input buffer overrun" reveal?

So... what is your literal source value? In your example, would it be 55 or literally the X'0055' string you've shown?

Assuming, of course, that this load happens in isolation.

Perhaps. Be patient.

Why are you surprised that it is telling you that a 50 character string may not fit properly in a 30 character target?

He asked if it has an associated value file.

There's a document here on detecting changes using stage variables. You can also add a Key Change Column in the Sort stage to help with this in a PX job.

Yes, the newline is simply part of the data when your input file is formatted like that. Strip them from the field in your job using Convert() and CHAR(13).

Easiest way to answer that question is to try it and see. Don't see why it wouldn't work, however.