DSXchange

is the "cxx" object being referred to a program or a script? Most likely a script, so you can edit it and see what it is doing. The cxx compiler isn't part of MKS toolkit.

If you create a new project and repeat the steps, does the project also get corrupted? Tracing and fixing what caused a project to be corrupted might take more time than just doing it again.

It would seem that your LIBPATH is wrong and doesn't contain the $DHSOME/uvdlls entry. Has someone changed your dsenv file?

The "cxx" script and compiler has nothing to do with DataStage; so you need to fix that first. Perhaps a compiler reinstall? Or MS Support? Or just look at the script and see where it references a cxx.ccg file and what it might be.

Bad explanation. But if you draw a reject link from the OP's DBStage2 and the output of Link3 into a funnel and then from the funnel to DbStage3 then the DbStage3 isn't written until the DBStage2 is completed. You need to change the funnel from continuous to sequential though.

And have you fixed your path to correct the problem?

Craig - you shouldn't have doubted me Using a reject link from the first stage (that produces no output) going to a funnel stage coming from the transform stage and using "sequential" method ensuring that the reject link gets processed first you do get a temporal dependency

Everything you posted indicates that the file does not exist. How do you know that it does exist in that location?

Marbis - although the whole post is probably not visible to you, the answer to your question is in the previous post and should be enough to get you going.

It is the transformer that is called "TRANS4" in your designer.

This is an ODBC definition issue, i.e. how do you tell an ODBC connection to go to a specific Excel tab. As far as I know, it cannot be done.

Could you format your post (put it into code-tags). I read it as have a 2nd output link from the Oracle stage and responded with my post, but now I see you probably wanted the links to come from the transform stage. The result remains the same, both links would go concurrently. I wonder, though, if ...

The error can happen for any number of reasons, but is seldom, if ever, cause for a corrupt project and certainly not a reason to delete it. It sounds like you have serious problems in your installation.

Is it actually version 6 of Server? Can you now create a new project without error messages?

Also, manually enter the command cxx -O -IC:/Ascential/DataStage/PXEngine/include -W/TP -W/EHa -DAPT_USE_ANSI_IOSTREAMS -c C:/Ascential/DataStage/Projects/ram/RT_BP1.O/V0S6_test_tx_Transformer_6.C -o C:/Ascential/DataStage/Projects/ram/RT_BP1.O/V0S6_test_tx_Transformer_6.tmp.o from the command line ...

What you are trying to do is not possible in PX. An database stage can only have one data output and, optionally, one error output. In order to ensure that Stage3 is filled once Stage2 has completed writing and committing work you will need to use 2 jobs.