DSXchange

The issue is with whatever wrote the VarChar columns into the table. VarChar will preserve blanks if they are there. Maybe you can update the table manually to TRIM this column?

Because the process doing the validation can not write to C:\Temp folder.

One. It sleeps on a semaphore.

What's your question?

Where have you stored the Parameter Set? Can you not edit it from there?

Welcome aboard. Do you have DS_* and RT_* files/directories in your project directory? If not "someone" has deleted them, maliciously or otherwise and you can not get your project back unless you have a system backup. The I_* directories contain the secondary indices on the repository tabl...

Usually this means that the project needs to be re-indexed.
Search for the DS.REINDEX command and the caveats on its use.

Yes it can. Read any good manual on sorting, particular heap-merge sort.

Try using an operating system sort utility.

999 is still MB, and still smaller than 1.6GB, so it still won't fit.

"Interesting" is what happens when you exhaust available memory and start getting access violation errors.

In your user variable convert the line terminators (which have by then been translated into field marks) into your preferred delimiter, and perhaps strip the final one. Left(Convert(@FM, ",", EC.$CommandOutput), Len(EC.$CommandOutput) - 1) Refer to the user variable in the "list of th...

My guess is that the file system on which /tmp is mounted simply does not have enough space for the temporary files (named pipes, effectively) used by the Link Collector stage.

I'm thinking along the same lines as Arnd - was one of the exports "include default values"?

You also need to verify that you can save that particular table definition from work (that is, with VPN not part of the equation).

If Dennis had wanted you to have a life he would have issued you with one.


Back to the galleys!

When's the interview?

By "lookup" do you mean the stage or the technique?

Yay!