I am pulling data from our HRIS system into a csv file with some basic employee information. I am passing it to a SQL table called employee with SSIS. I have this working but every time I run the package, it is adding duplicate employee records to my table. Do I need to use a lookup or something in between. I want the data coming in to update the table if the person already exists (I can use a column called clock_no to verify) and if its a new record I also want to add. Can someone tell me the best approach to accomplish this?