I am trying to accomplish the following:
I need to query a table in a database on Server1, and also query a table in a database on Server2 based on a piece of data in the 1st query (e.g. list all the records in query 2 where they equal the 'Apple' from query 1).
I am currently attempting to use 2 OLE DB Sources linked together by a Merge Join output to a Dervice Column for mapping, and then update the table on Server 2. Should I use UNION All instead of Merge Join? How do I run the Select in query 2 based on the output of query 1?
Thnak you, WHEELS