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.
www.techbrother...

[@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

[@TechBrothersIT]

krismaly Thanks:)

[@krismaly1231]

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

[@krismaly6300]

Revisiting I enjoyed watching this video and recommend others to watch. Thanks for educating the community and appreciate your efforts

[@rashmi933]

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

[@TechBrothersIT]

+Rashmi Sinha Thanks for kind words dear. You made my day. Glad to hear you liked my effort. Stay blessed and thanks for watching.

[@TechBrothersIT]

+Rashmi Sinha You are very welcome and thanks for leaving nice comments and blessings. Stay blessed and all the best with learning MSBI.

[@lokoness]

many thanks my friend (nice !!!!!,nice !!!!!,nice !!!!!,nice !!!!!,nice !!!!!)

[@KitoKitko]

Thank you for sharing.

[@davisfamily5442]

Thanks!

[@chaudhryalisalam3668]

great job sir

[@danieljoubert7937]

Thanks

[@krismaly1231]

Awesome.

[@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

[@TechBrothersIT]

Hi, you are welcome.I would suggest to load the data into staging table and check by using Execute SQL Task and use the Precedence Constraint to stop the flow to load the records.

[@Pr0x1mo]

Fucking beautiful, bro.

[@TechBrothersIT]

:)

[@accent5670]

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

[@TechBrothersIT]

You mean that you have 80 fields?

[@accent5670]

My bad... yes sir actually we deliver raw file before processing it to some customers for comparison which has more than 80 fields and I did write a query to find the count of not nulls in each fields but it ran for more than 2 days but ultimately got the result... other way I found to do was write awk script which got executed in 5hrs but if I have to write a query and still get it run efficiently then what's the solution.. thanks