DELETE old Records in List

Apr 10, 2009 at 4:03 PM
I am trying to Archive the completed task in my SharePoint List and then delete the archive from the list
I am able to copy all the data to a table but how to i delete the record I do not want anymore in my shareporint list.

Apr 10, 2009 at 4:14 PM
The destination component can either 'update' records using the given ID field, OR it can "delete' the records.  So if you setup an destination component, set the property, I think batchtype, to delete - any ID going into that adapter will be deleted from SP.  You cannot mix / match updates and deletes, and a delete only needs the ID column.