Union All Transformation in SSIS is used to
combine data from multiple sources (excel files, flat file etc) or
multiple SQL tables
and produce one output to store in the destination table. Union All
Transformation in SSIS does not follow any particular order while merging the
data and storing in the destination table
It will take
multiple inputs. It accepts unsorted inputs.
Taking Data
flow task
Double click
on the data flow task. Configuring the inputs source.
No need to
sort input data.
Now I am
executing this packing. See the output.
Not sorted
output.
