In your Excel source use SQL Command--
SELECT DISTINCT fld_Id
Where Sheet1 is the name of your worksheet.
Hope this helps.
- Proposed as answer by Megha Barpande (MCSE-Business Intelligence) Monday, May 06, 2013 9:56 PM
As far as I can see data is getting pulled from Excel sheet, so your OLEDB source is useless. Besides if VJ is interested in only 1 column from excel sheet he might as well use a command..Wouldn't that be easier? unless I have completely missed out in understanding the question!