hi, i dont know which component do i need to use for my req. i have 2 column from my table ,productid and productname now when file comes, i need to see if productid is match, if yes then if product name is empty then insert productname into productname column in table. now if both r match just ignore. what should i use ,i tried lookup but doesnt work

If you are thinking to write query then see MERGE explanation in below link from Pinal http://blog.sqlauthority.com/2010/06/08/sql-server-merge-operations-insert-update-delete-in-single-execution/ Regards, Vishal Patel My Blog

but how can u use merge in ssis

You can either use MERGE in an SSIS T-SQL task (after uploading your file to a staging table) or you can use a Data Flow Task with a MERGE JOIN (which is a heavy performance hitter) or possibly a LOOKUP (which can also be a heavy performance hitter). I recommend loading the file into a staging table and then using MERGE in the T-SQL task.MCITP:DBA, MCDBA, MCSA

You can either use MERGE in an SSIS T-SQL task (after uploading your file to a staging table) or you can use a Data Flow Task with a MERGE JOIN (which is a heavy performance hitter) or possibly a LOOKUP (which can also be a heavy performance hitter). I recommend loading the file into a staging table and then using MERGE in the T-SQL task.MCITP:DBA, MCDBA, MCSA