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.

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

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

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.


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.

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

Step 7: Execute the package.

Join the conversation! Your thoughts help the community grow.