Hi All, I have a question regarding...how to select distinct rows from input excel source...like we do in sql...? Is there any way to do that..? If so can you let me know. Thanks, vineesh1701

after the excel source, you can use sort transformation... there you find a check box for removing the duplicate records. try this.. Let us TRY this | My Blog :: http://quest4gen.blogspot.com/

Hi vineesh I believe you can build query against the Excel Sheet to return distinct record. E.g: SELECT DISTINCT A, B FROM [Sheet1$] In Order to build query select the DataAccessMode as Sql Command Instead to Table or view in Excel Source Editor. Regards Harsh