DSXchange

So... as strings, I assume?

Memory as in RAM... not hard drive storage.

Let's get some specifics before we play anymore guessing games. Show us the definitions of your target fields: name, data type, precision. Saying they are 'quite large' doesn't exactly narrow it down.

I'd also be curious what their definitions are in the job itself.

Have you tried trimming the values before sending them to the target?

Very interesting...

Could be a memory leak... that kind of thing can cause a slowdown that only a reboot / restart would clear up. I'd check with your official support provider (or check what is it called, Fix Central?) to see if there are any client-side patches for the issue. As a guess.

NLS issue? Meaning, are you dealing with a multibyte character set?

Search is your friend, if not here then out in the wild. One example here and there were plenty of others. Always better than simply repeating your question.

Not sure how much more help anyone here can give - everything reasonable has been tried and it doesn't seem to make any difference. At this point it seems you need "boots on the ground"... i.e. someone there who can see what you are doing and apply direct pressure to the wound. Failing tha...

Just that you were executing the correct one and not some rogue copy someone had planted elsewhere.

You're fine.

Good catch! :D And in case anyone was wondering why the two examples of spaces in a string look the same, that's because the forum software automagically removes any 'extra' spaces, so the quotes with four spaces between them end up looking the same as the quotes with one space between them. Code ta...

So have you found it elsewhere?

Yay for Server jobs! Reports of their death have been greatly exaggerated. :D

... and that is a completely different discussion.

It's not a syntax I've seen in the wild, only posted here by Ray. :wink: The Value Mark allows you to do multiple transformations without in-lining the function call repeatedly. So it is equivalent to: IConv(IConv(myDate,"DYMD"),"MCN") However, it makes no sense to me as "MC...