Hi,i have downloaded SharePoint List Source and Destination tool from Codeplex .And i can successfully import the data from sql server into sharepoint list with SSIS, but i don,t know how to delete and update records in sharepointlist ,using SSIS? Anyone here, can help me ?Thanks a lot!

Have you set the BatchType property on the SharePoint List Destination component?John Welch | www.mariner-usa.com | www.agilebi.com | ssisUnit.codeplex.com

I am having a similar problem to "manladies". I can use the source just fine, and yes I've tried the properties on the Destination component ... however I cannot use the Destination component at all.The Destination component loads with the middle tab labelled "Input Columns" just like in the instructions on how to use the Destination from this URL: http://msdn.microsoft.com/en-us/library/dd365137.aspxBut this leaves the component with the error "There are no columns mapped to the output columns". And in no way can I see or specify or map output columns. If I try to add them manually, the system errors that the component cannot have outputs.So how do I use a Destination that requires outputs when it cannot define outputs?

Have you configured the SiteURL, and SiteListName properties on the Destination? It sounds like the Destination is not pointing to a list.John Welch | www.mariner-usa.com | www.agilebi.com | ssisUnit.codeplex.com

Yes, everything was configured correctly.I found a workaround, also posted the same to CodePlex.I am unable to make the Destination work if I first connect the Source Input path to the Destination and then edit the Destination node. It never works.However, if I edit the Destination node before connecting a Source then the output columns show up. Click "OK" and then join the Source and then re-edit the Destination and I am able to map correctly.We must have some software installed (or a bad patch or something) that is causing that behaviour, but the component works if I do that sequence of actions.

This is how we have done the deletion of sharepoint list data : Take Sharepoint list source , configure the require things.Select ID column as output column. Take Sharepoint list Destination , configure it with connection.Go in the component properties Tab,under Custom properties select Batch type as Deletion or Modification.In the column mapping map the Id output column to Destination ID column. hope this will work for you. Regards Samay samay