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.
Your blog is in a convincing manner, thanks for sharing such an information with lots of your effort and time sql dba training
ReplyDeleteSuch an informative post Thanks for sharing. We are providing the best services click on below links to visit our website.
ReplyDeleteInformatica Cloud Training in Hyderabad
Informatica Online Training
Informatica Training Online
Informatica Training in Ameerpet
Informatica Cloud Training
Informatica Cloud Online Training
IICS Training in Hyderabad
Informatica Training in Hyderabad
Informatica cloud Online Training in Hyderabad
Such an informative post Thanks for sharing. We are providing the best services click on below links to visit our website.
ReplyDeleteInformatica Cloud Training in Hyderabad
Informatica Online Training
Informatica Training Online
Informatica Training in Ameerpet
Informatica Cloud Training
Informatica Cloud Online Training
IICS Training in Hyderabad
Informatica Training in Hyderabad
Informatica cloud Online Training in Hyderabad