SQL Server Integration Service (SSIS) 2017 - Conditional Split

In this post I am going to explain how to use conditional split tool.

I am using 'StockItemHolding' table which includes many records.There is a column called 'Lastcost price'.

As per the above screenshot, using Conditional split I am moving lastcostprice which is grater than 10 records to StockItemHolding_split_1 table  and lastcostprice  lessthan 10 records to StockItemHolding_split_2 table. Initially there is no any records in the destination table.
StockItemHolding_split_1

StockItemHolding_split_2

Drag and drop the Data flow task into Control flow.

As per the below screenshot add components into Data flow tab.

OLE DB Source Configuration

Conditional Split Transformation configuration

StockItemHolding_split_1 table Configuration

Mapping tab configuration.

StockItemHolding_split_2 table Configuration

Mapping tab configuration.

Execute the package.

Now you can see lastcostprice  graterthan 10 records stored in the StockItemHolding_split_1 table

you can see lastcostprice  lessthan 10 records stored in the StockItemHolding_split_2 table

Hope you have understand the Conditional split component. To see the more SSIS tutorials refer the http://pubududewagama.blogspot.com/

Thank you !!!