Jasinski Technical Wiki

Navigation

Home Page
Index
All Pages

Quick Search
»
Advanced Search »

Contributor Links

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

Other Wiki Sections

Software

PoweredBy

Merge Join Transformations - SQL Server Integration Services

RSS
Modified on Tue, Sep 29, 2009, 2:14 PM by Administrator Categorized as SSIS (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.
    Image


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


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

Image

  • 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.
    Image


  • 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.
    Image


  • Do the same for the other OLE DB Source.

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam. Except where noted, all contents Copyright © 1999-2018, Patrick Jasinski.