I solved this isuue by using RetainSameConnection =TRUE for the connection manager and setting DelayValidation =TRUE in the dataflow.

Thanks,

Sabina

Thanks, it's working fine

I think I have to rephrase my question. The question is I have 3 sources and based on requirements either data goes to destination table or output table (bad date)....