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