Which part are you using to do the deletes the DDQ or the MPDP? You
certainly do not need the latter to do the deleting and inserting in one
motion. I am not sure you can grab the properties you want in the middle of
the task as the only real way using the object model is a property of the
Task and those methods are

RowsInError
RowsAffected

This is a property of the task as I said so I do not think you will be able
to call out to this mid task in the Post Row phase perhaps. You will need
to do it in the Post Row phase as the DDQ operates on each row and you take
actions based on the data in the row.

I have to say I have never tried it.



--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

[quoted text, click to view]
functions to insert and delete rows from a table. Can anyone tell me if it
is possible to get the row count for the action queries during the "row
transform function". The query executed during the row transform function
phase is based on a column in the source table. I want to be able to
determine how many rows the DeleteQuery effects for the current source row.