Just to clarify I meant the OLE DB Sql Command is run for every qualifying row not every row

I would add that the times I have seen the OLE DB Command used is normally to simulate some kind of MERGE. My experience has been it is faster to do that kind of thing in Pure Sql, if you are able to do so.