DSXchange

If all the OP wants is to get records with same keys (col x and col y) and colA to be between the last two columns, then my solution should work. If there is an issue of setting all four columns as keys then your right, a different approach is in order.

chulett wrote: Fix one and fix the other.

Thats right, two birds with one arrow.

I did an exact search on 'output file full' and it returned me 8 posts. Try searching again.
The error is pretty much what it says, your output file is full. Your hitting the 2GB limit. Its, but, obvious. A full outer join of 30M to 30M.

Who said anything about a date . Just messing with ya Craig.... Coming back to the OP's quest, This should be fairly easy. Mark col X and col Y as keys while building your hashed file. Do a lookup in the transformer on your keys. In the output link provide the constraint NOT(reflink.NOTFOUND)...

Try the 'type filename.txt' from command prompt. See if it works ok from there. Lets try to fix your first problem first. Second should go away on its own, once your get your command activity working.

No. you need to put the word 'type' before the path and file name. 'type' is the dos command to spit out the contents of the file onto the screen.

chulett wrote:You were supposed to 'type' the file, not try to execute it.

Beat me to it

Did you put 'type' before the file's fully qualified name? Does'nt look like it. Put type before your file name.

Thanks for the clarification Craig. I couldnt remember the exact options off of my head as i havent used that option in ages.
I hope the OP is actually choosing those options from the drop down rather than typing it, which he probably is as the job ran and aborted.

You can also check with Ray as he offers server to parallel transition classes.

What does the log say?

Did i say $Return_value. SOrry, you need to pick $Command_Output.

Ray, Ernie; are you guys up for the challenge

O yea. Remember seeing one of those at my uncle's place. Some invention that was.

Clear out all the threads. Clear out the status file as our good friend Whale suggested. As for the error, how many of those columns are of type varchar or char. For each of those columns specify EREPLACE(in.Col, '"','') the second argument is singlequote, double quotes, single quote an...