There is an unsaved comment in progress. You will lose your changes if you continue. Are you sure you want to reopen the work item?
SharePointList Destination Adapter Deletions
Trying to delete items from a Sharepoint List using the Sharepoint List Adapter.
Using the Sharepoint List Source adapter to import to a SQL 2K8 table the items in a list works fine. A table is populated with List items including an ID column.
Setting up a dataflow task that selects one row of this table with SQL query in an OLEDB source and passing that row to the Sharepoint List Destination with the Batch Type = Deletion on this data flow component, the dataflow task succeeds, but no rows are deleted
from the list.
Previewing the records from the OLEDB Source shows the one record that I'm trying to pass through, my runtime view of the dataflow component shows 1 row sent from source to destination, but execution results shows Sharepoint List Destination wrote 0 rows.