SSIS - Data Flow - two lookups to the same table
Posted on 2010-09-16
In my data flow, I need to run two different lookups to the same table and pull out different values. What I'm getting is that when I build the second lookup, it assumes I'm doing the same type of lookup and automatically uses the link built from the prior lookup and does not allow me to build new relationships in the 2nd lookup.
How can I build the lookup so that I can reference the same table but under different relationships?