DSXchange

hi,
my source is sql server
target is sql server.
my design is
iam using DRS stage to connect to SQL server and a transformer stage to perform transformations, and DRS stage as target.
i created another link from the transformer stage to sequential file inorder to catch the rejected rows.

i specified a constraint in the transformer stage,when specifying constraint properties.
i declared as
dslink4- dslink3.city='Berlin'
dslink6- dslink4.Rejectedcode
for specifying DSLINK4 as rejected row, i have checked that link.
here DSLINK4 AND DSLINK6 ARE OUTPUT LINKS AND DSLINK3 IS INPUT LINK.
i want to specify DSLINK4 as rejected link.
iam getting error in the transformer stage.
plz help me.

cheers;
vijay

You never mentioned what error message are you getting.
Change DSLink6 constraint to. You will also have to specify transaction size of 1 for this functionality to work properly. And there is a performance price to pay.
Uncheck the Reject box.

If you want to specify DSLink 4 as the reject then give the constraint
dslink3.city='Berlin' against DSLink 6 and check the Reject Row check box for DSLink4.

What error are you getting?

Hi Vijay,

What is the error message you are getting?

Sam

It is impossible to help you without knowing exactly what error message you are getting. Otherwise your question is like "my car won't start - what's wrong with it?".

hi Gurus,
i have connected DSLINK4 to DRS STAGE AND DSLINK6 TO SEQUENTIAL FILE.
i want all the rejected rows to go to SEQUENTIAL FILE.
i specified constraint for this.

linkname constraint rejected row abort after rows

DSLINK4 DSLINK6.REJECTED 0

DSLINK6 DSLINK3.CITY='Berlin' checked 0

here DSLINK3 is the input link.

iam getting error as ERROR PROCESSING TRANSFORM DERIVATION FOR TRANSFORMER STAGE.
plz help me.

cheers;
vijay

Your explanation does not make sense.
You said

i have connected DSLINK4 to DRS STAGE AND DSLINK6 TO SEQUENTIAL FILE

SO that means DSLINK6 is the reject link.
But you say

DSLINK4 DSLINK6.REJECTED 0

DSLINK6 DSLINK3.CITY='Berlin' checked 0

The link that is going to the DRS stage is used in the reject link's contraint as follows

hi,

Thanks very much.
once again thanks.

cheers;
vijay