• That's what I am forced to do.I wish Lookup could handle that.We cannot use variable in Lookup transformation.

    Will also try with LOOKUP PLUS from Codeplex.