How to remove blank rows or empty rows in SSIS Data Flow task from a Flat file source or Excel Source, Raw source

How to remove blank rows or empty rows in SSIS Data Flow task from a Flat file source or Excel Source, Raw source


Here I have a flat file source which has some blank values
































Simple and easy trick