Gotcha.

Thanks for the reply 🙂

There's definitely better performance happening when I just query across the linked servers! Thank you!

But if the tools in SSIS behave so poorly..why are they there? Are they meant for...

So join/linked server would (and do) work...any reason *not* to use the lookup in SSIS with a cache connection manager?

da-zero (10/4/2010)

---

Raunak Jhawar (10/4/2010)

---

da-zero (10/4/2010)

---

Raunak Jhawar (10/4/2010)

---

Lookup is always in favour for the reason that no explicit sort is mandatory and the prior to join and check data can be...