Merge and Merge Join Task

Question

What are the purpose for Merge and Merge join Tasks in Data Flow ?

Answer 1

it combines to paths in the data flow, you can choose which columns to merge together, so if you have two data sources and you want to combine, you can merge on columns and come out with one output, and insert that output or put it to a flat file, for example, instead of writing two output.

Answer 2

I think the merge task is like doing a union in a sql query whereas a merge join is like doing an Inner/Left join in SQL