Insert and update Sharepoint list items using SSIS

Jan 28, 2010 at 2:59 PM


I 'm new with Integration service, and i try to create an offline sharepoint list to let the customer entring the data offline then apply all changes he did to other sharepoint list with the same structure as offline one.

I have alrady sharepoint list has data on sharepoint site , i got a template from this sharepoint list included the content then create new sharepoint list from this template then  create new integration service package and drag sharpoint list source and destintion from toolbox to control data flow tab and follow the instruction to set the porperties for source and destintion.

i want to update the old data and insert the new data from the sharpoint list i created from the template to the old one i have.

after read micrososft articles in this matter, i reach to

If i assign the ID to ID the data updated successfully, but if i assign ID to Null the new item inserted but this approche ReEntering the old data again !!

could you please guid me to suitable approche to bind the update the old data and insert the new one?

Thanks in advance.

Qassem , Sharepoint Developer

Jan 31, 2010 at 10:59 AM

Any advice , Please?