SSIS Tutorial Part 70-How to Filter Rows with Blank values in Data Flow Task in SSIS Package

In this video we 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.

To follow Step by Step SQL Server Integration Services(SSIS) Video Tutorial By TechBrothers, please open below link.

Twitter

Facebook

[krismaly]

I enjoyed watching this video and recommend others to watch.
I saw there is a TRIM() function in that list, I think probably you missed while scrolling.
I used TRIM() it worked fine.

Thanks for educating the community and appreciate your volunteer-ship.

Thanks

[meriemmezhoudi]

the best MSBI youtube channel thank you

[jonatanlambert]

another interresting video that you TechBrothersIT

[krismaly]

I enjoyed watching this video and learned something. Thanks for educating the community and appreciate your efforts and volunteer-ship. Please keep educating the world.
Thanks a bunch

[Chillos]

Thank you very much!! much appreciated

[ryandsouza]

How do we handle an entire blank row that may show up between good rows of data

[ahmedsalama]

what about files you use in your tutorial ??