Use of UnionAll Component :

The Union All component is used to combine more than one input 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.

UnionAll1.gif

Step 2: Drag and drop a Conditional Split component from the toolbox and connect the input.

UnionAll2.gif

Step 3: Edit the conditional split component. Add the following condition as mentioned below.

UnionAll3.gif

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.

UnionAll4.gif

UnionAll5.gif

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.

UnionAll6.gif

Step 6: Place one more row count component after the Union all component, to get the total row count.

UnionAll7.gif

Step 7: Execute the package.

UnionAll8.gif

Next Recommended Readings