• Thanks michel,

    Actually, i would like to insert what are the rows the source table have and does not have the destination and also changed rows in the source table in to the destination by using conditional split transformation after the Lookup.

    in this regard iam getting error.

    any suggestions pls