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...
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....
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'.
-craig
"You can never have too many knives" -- Logan Nine Fingers