Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Content with tags Integration Services (SSIS), merge join Rss

   Items 1 to 1 of 1   

SSIS Basics: Using the Merge Join Transformation

SSIS is able to take sorted data from more than one OLE DB data source and merge them into one table which can then be sent to an OLE DB destination. This 'Merge Join' transformation works in a similar way to a SQL join by specifying a 'join key' relationship. this transformation can save a great deal of processing on the destination. Annette Allen, as usual, gives clear guidance on how to do it.  Read more...
By Additional Articles 2013/10/28 | Source: SimpleTalk | Category: integration services (ssis)
Rating: (not yet rated)  Rate this |   Briefcase | 3,878 reads
   Items 1 to 1 of 1