Reconcile ADO Dataset From ActiveX Script Task

I'm having a bear of a time with this. I have a recordset that pulls data from one, single table. I would like to iterate through the set, do some processing based on that data, then delete all of the records in that recordset.

I'm trying to do something like the following:


Set dbConn = CreateObject("ADODB.Connection")
Set dbRS = CreateObject("ADODB.Recordset")

dbConn.Open("myConnectString")
dbRS.open dbSQLCmdText, dbConn, 2, 4

While Not dbRS.EOF
Do some stuff
dbRS.Delete
Wend

dbRS.BatchUpdate

dbRS.Close
dbConn.Close


I get an error stating:

"Multiple-Step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done."

This seems to indicate the connection doesn't think it's capable of reconciling the recordset. Is there a way to do this in one batch or should I stick with executing a single delete statement for every record in my recordset?