DSXchange

i have designed a job like ODBC enterprises as source and target... in between source and target one transformer for mapping... problem is NULL values from source are getting rejected in the transformer.. i wants to get it into the target... in the target i have defined all the columns as null able but still values are getting dropped...


please help me in this issue.....

thanks....

Any particular messages being logged by the job? How exactly are you doing your null handling?

if the column value is NULL... its getting dropped... its going to reject link from the transformer.. i am not doing any null handling.... as of now i am using stage variable, constraint and sending to target.. but without that i wants to send to target....

my question is why the null values are getting dropped....? why its not going to target...??? any setting has to be done in transformer..?????

Please answer both of my questions. Are you using any constraints on your (non-reject) output links? Rows will 'reject' if they go down no other link or if there is a 'write failure'.