SSIS merge join multiple results

• Trybbe

  Hall of Fame

  Points: 3967

  More actions

  January 17, 2013 at 11:56 pm

  #288176

  Hi,

  Is it possible to combine results from four different queries before sending to destination. something like a union. If possible how do I go about doing that

• Jason-299789

  SSC-Insane

  Points: 21601

  More actions

  January 18, 2013 at 12:26 am

  #1578569

  It is, BUT it depends on the data in the streams and how you want to merge the streams.

  You could use a UNION task if you want vertical integration, but I think all datasets have to have the same number of coumns and the columns have to be the same datatypes.

  If its a horizontal union (Merge/Join) however I believe you are limited to 2 datasets per Merge/Join Task, so for 4 data sets you would need a minimum of 3 tasks, and it would be a case of merging the data sets in pairs first then using a final merge to join the output of those tasks to get your single data set.

  Or you could merge 2 datasets, then pass that into a merge task for the 3rd data set and then pass that output into a 3rd for the 4th dataset.

  _________________________________________________________________________
  SSC Guide to Posting and Best Practices

• Trybbe

  Hall of Fame

  Points: 3967

  More actions

  January 18, 2013 at 6:36 am

  #1578684

  Hi Jason,

  Thanks for the feedback, the union transformation did the trick