November 25, 2013 at 8:47 am
Good morning.
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
November 26, 2013 at 1:57 pm
Merge join is the right choice here. If you are facing any discripencies in the result set, do check for the null values in your mappings; and make sure source data for Merge transformation is sorted
November 27, 2013 at 5:15 am
Thank you. I really appreciate the assist. WHEELS
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply