How to Filter Rows with Blank values in Data Flow Task in SSIS Package

In this video of SQL Server Integration Services(SSIS), you will learn how to filter blank rows in data flow task by using conditional split transformation. 

The video also introduce you to write expressions in Conditional split transformation, How to use Trim functions such as LTRIM and RTRIM to remove blank spaces from data points in Conditional Split transformation.

The video can be used for beginners to learn about different SSIS Transformations and Tasks such as Data Flow Task, Flat File Source, Conditional Split transformation and Multicast Transformation. The use of Multicast Transformation in this demo is only for Test purpose.