Hi all, I came across below scenario I have an excel file with columns EMPID, EMPNAME, GENDER where gender has values 'M' and 'F'. By mistake 'M' and 'F' used interchangingly i.e. for males gender is marked as 'F' and for females gender marked as 'M'. The problem is to correct this gender mismatch issue using SSIS. Let me know if anybody have suggestions. Thanks in advance, Durga

HI Durga, You can use a lookup for the destination excel sheet and update the excel sheet for the existing values with correct values using an OLEDB command for the match output. The OLEDB command will update the existing sheet with correct values.Happy to help! Thanks. Regards and good Wishes, Deepak.

in the ssis data flow, after excel source; you can use a Derived Column Transform, with this expression: [Gender]=="M" ? "F" : "M" then you can replace new column with previous gender column in data stream in derived column and map these column to an excel destination, new file will have correct Gender valueshttp://www.rad.pasfu.com

Hi all, I came across below scenario I have an excel file with columns EMPID, EMPNAME, GENDER where gender has values 'M' and 'F'. By mistake 'M' and 'F' used interchangingly i.e. for males gender is marked as 'F' and for females gender marked as 'M'. The problem is to correct this gender mismatch issue using SSIS. Let me know if anybody have suggestions. Thanks in advance, Durga If your purpose is to correct data in excel only and nothing else then no need to use any tool, you can do it in excel itself.