Balanced Data Distributor – Using Conditional Split...

Balanced Data Distributor – Using Conditional Split...

It’s Conditional split is used to split the data based on Conditions. It requires atleast one Key Column to perform the operation. 

Step A: Create a package with Data flow task and Name it as dftConditionalSplit

Step B: Add the respective Source with proper table Name using the Select Statement or table or view options as shown below. I took the table/view - which will decrease the performance.

Step C: Connect the Conditional Split with the Source and Destination 

Step D: Add the cases as shown below, the cases should be in Descending Order, because the values 8, 6, 4, 2 are divisible by 2 and 9,6,3 are divisible by 3, So all the records will go into 2 and 3 instead of 4,5 & 6.

Step E: Create only one table with proper structure as shown below, Since we are going to move the data from One Source to One target table with N - Number of Destination

Step F: Execute the process, where Yellow means the SSIS is still processing the data.

Step A: Execution completed, Check the data

Hope it helps in understanding the Performance.

Happy Coding :-)

Regards,

Daniel J.S BE CSE, MBA Entrepreneur,
Data Warehouse and Data Mining Architect,
+91 8939574948...