Navigation

	Home Page
	Index
	All Pages

Contributor Links

	Create a new Page
	Administration
	File Management
	Login/Logout
	Your Profile

Other Wiki Sections

Software

Merge Join Transformations - SQL Server Integration Services

• On the Control Flow tab, add a Data Flow task, then double-click it to navigate to the Data Flow tab.
  
  

• Add two OLE DB Sources and a Merge Join transformation.
  
  

• Right-click either OLE DB Source and select Show Advanced Editor from the context menu.
  

• In the Advanced Editor, select the Input and Output Properties tab, select OLE DB Source Output in the left pane, and set the IsSorted property to True.
  
  

• In the left pane, under OLE DB Source Output > Output Columns, select a field to sort by — typically the primary key — then set its SortKeyPosition property to 1.
  
  

• Do the same for the other OLE DB Source.