Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS SQL Serveer 2008 R2 Expand / Collapse
Author
Message
Posted Monday, November 25, 2013 8:47 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, March 6, 2014 10:11 AM
Points: 12, Visits: 24
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
Post #1517302
Posted Tuesday, November 26, 2013 1:57 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, October 9, 2014 10:18 AM
Points: 164, Visits: 94
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

http://technet.microsoft.com/en-us/library/ms141775.aspx
Post #1517822
Posted Wednesday, November 27, 2013 5:15 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, March 6, 2014 10:11 AM
Points: 12, Visits: 24
Thank you. I really appreciate the assist. WHEELS
Post #1518017
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse