What about using a global package variable and incrementing it in the transformation script. It seems that you're stuck using the DDQ to write the record count to a table. It doesn't appear that you can reference the GlobalVariable collection from a SQL Task.
