I'm getting into trouble everytime I want to setup a dataflow containing 2 or more flows, where I want to make a lookup into 1 other table.
This fails, of some reason I do not know of.
ex.
Table 1 -> Lookup Currency Table -> Table2 with currency
Table 3 -> Lookup Currency Table -> Table 4 with currency
One of the lookup will fail.
How do you avoid this?
/Bjarne
You meant, you have more than 1 source component in your data flow that goes independently of each other toward different lookup transformations?
How are you setting the lookup transformations? You shoud use a query to get only the columns you need and since the lookup table is used concurrently; you may want to use nolock hint to avoid deadlocks.
Are you actually receiving any error message?
Rafael Salas
