I have been asked to see if I can create a way to send a SharePoint list to an SQL table. So I downloaded and installed the SSIS SharePoint List Adapters for SQL Server Integration. Setup a new project in Visual Studio 2008.
I then setup the Data Flow where I have the SharePoint List as the source and OLE DB as destination. I mapped the columns I wanted. Made sure the data types match, etc...Ran the project and everything was fine. No errors or warnings. I saw the data in the
SQL table. Then I ran the project again and it seems like everything gets duplicated. So initially SSIS sent 80 records from SharePoint to SQL then the second time I ran it it sent the same ones again so I now have 160 records in SQL.
Is there any way to only transfer new entries or ones that have been updated?
I tried searching but do not see that option anywhere.
This is my first time using VS2008 and SSIS.