Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have successfully connected a sql data base to a sharepoint list using ssis. The problem is that every time I run the project all the data gets dumped into the list and causes duplicates. Is there a way to not import the duplicate entries?

share|improve this question

You could pull it into a temporary table and run an 'UPSERT' set of statements to get the new records into the table.

If you are on sql 2008, you could use the new MERGE functionality.

An UPSERT consists of an INSERT for new records, UPDATES for existing rows that need to reflect changes in the source and DELETES if desired.

You can do this in a stored procedure which you can call from a execute SQL step.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.