SSIS Excel Data Source Issue
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
August 20th, 2011 8:11am

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.
Free Windows Admin Tool Kit Click here and download it now
August 20th, 2011 10:20am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics