SSIS Tutorial Part 69-How to Filter Rows with Null Values in Data Flow Task in SSIS Package

In this video you will learn how to convert blank values into Null values in Flat file source in SSIS Package. The second part of the video explain how to filter the rows with Null values by using Conditional Split Transformation. The video also explains how to use Data Viewer in Data Flow during debugging your SQL Server Integration Services Package. The scenario covered in this video is real time and we often have the requirement to ignore/filter rows with null or blank values. Video also introduce you to different SSIS Functions available and specially how to use ISNULL In SSIS Package.

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

[krismaly]

I recreated the package as per your steps and it is working fine.
I recommend others to watch.

Thanks for educating the community.

Wish you good Luck in your endeavor.

Thanks a bunch

[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

[krismaly]

Revisiting

I enjoyed watching this video and recommend others to watch.

Thanks for educating the community and appreciate your efforts

[rashmi]

Thank you so much Aamir for educating us, May God bless you !

[alejorom]

Hello TB-TI
Thanks for the sample.

Now I have a question?
Let's say our requirement says "If one record (firstName) is null do not load any records at all". So, how do you condition that output?

Thanks

[accent]

I have around 80 rows how do I filter those as it is not feasible to drag all the 80 fields to conditional split