How to use Union all component?
Use of UnionAll
Component :
Union all component is used to combine more than one inputs
to a single output.
Step 1: Create a
DataFlowTask Component .Edit the dataflowtask and add an OLEDB Data source.
Connect the OLEDB datasource with the database.
![u1.png]()
Step 2 : Drag and
drop a Conditional Split component from the toolbox and connect the input.
![u2.png]()
Step 3 : Edit the
conditional split component. Add the following condition as mentioned below.
![u3.png]()
Step 4 : Drag and
drop the RowCount component and connect it mentioned below. Assign the
variables also to store the RowCount value from the RowCount component.
![u4.png]()
![U41.png]()
Step 5 : Now the
empty records and non-empty records are separated , to join this one , we can
use union all to merge this two branches.
![u5.png]()
Step 6 : Place
one more row count component after Union all component , to get the total row
count.
![u6.png]()
Step 7 : Execute
the package.
![u7.png]()