SSIS package

[Pranav Thakur]

Hi, I have successfully implemented insert/update logic in my SSIS pacakge. If a new project id is found in the source file then I insert a new row in the database table. If an existing project id is found then I update the corresponding row in the table. The above logic work fine but not in case if there is multiple identical project ids in the source file. The update logic fails in this case. I though of deleting and then inserting the rows for update logic but could not do so. Can anyone help. I am using lookup control and contional split control for identifing the existence of a new row or existing row.