Post reply

SSIS merge join multiple results

  • 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

  • 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

  • January 18, 2013 at 6:36 am

    #1578684

    Hi Jason,

    Thanks for the feedback, the union transformation did the trick

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply