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.

file attachments

Closed Sep 2, 2008 at 3:35 PM by kevinidzi


kevinidzi wrote Aug 26, 2008 at 10:29 PM

Well, If the ID was not found in the sharepoint, you'd see this in the execution results:
[Sharepoint Destination] Error: Error on row ID="1": 0x81020016 - List item referred to in the request does not exist. 
After running this a few times, I did see something that should be fixed. In the execution progress, there are two messages. One is an info event that sayss how many affected rows in the listname, with the site url and the elapsed time. That message is correct and should should your # of rows .

There is another one after that which shows for the component that it wrote 0 rows (bug).

So try it again, and don't look at the bottom message, look for the one above which has the elapsed time and other info. That should show the correct rows. And I'll put on my list to fix the 0 rows in the followup message.

Thanks for reporting this.

MichaelBishop wrote Aug 27, 2008 at 3:39 PM

I'm not getting the List item referred to in the request does not exist error, but the SharepointList Destination is not deleting any items from the list, even when passed a valid ID.

So, the fact that the component's execution progress shows that it wrote 0 rows is accurate. 0 rows had a delete performed by the destination adapter.

wrote Aug 27, 2008 at 5:36 PM

kevinidzi wrote Aug 27, 2008 at 5:39 PM

This informational message has been fixed for the source and destination component. It will be included the next release of this component.

wrote Aug 27, 2008 at 5:39 PM

wrote Aug 27, 2008 at 11:02 PM

wrote Sep 2, 2008 at 3:35 PM

Resolved with changeset 16928.

wrote Mar 3, 2010 at 6:01 PM

wrote Feb 22, 2013 at 12:32 AM

wrote May 16, 2013 at 11:45 AM