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

Advertisements

How to remove duplicates rows in SSIS data flow task from a Flat file source or Excel source, Rawsource

Hi , Using a simple trick you can easily eliminate duplicate rows when using Flat file or Excel source or Raw source or any where in the Data Flow task























Simple and easy trick you can using any where in the Data Flow task

Thank you

SQLJUNKIESHARE