Hey there,

I need to do a lookup within SSIS, however I need to be able to reach
across / join to two disparate servers / databases in my lookup.

However, the SSIS Lookup object only has 1 “OLE DB Connection manager”
connection at its disposal.

E.g.
SELECT dw.CountryKey, lir.CountryCode
FROM DB1.dbo.Country lir
JOIN DB2.dbo.CountryLookup dw
ON lir.ISOCountryCode = dw.CountryCode

Again, both DBs are on separate servers, so connection strings are
needed to avoid hard coding.

So I could use some help in how to best achieve my multi-server joined
lookup. Any ideas?

Thanks so much,

dave