Bill,
The only way I've been able to do this is:
Procedures: Get the count and return it to DTS using an Output parameter (into a global variable). This can be tricky to set up, but it works.
DTT: use a activex script to increment a global variable for each row returned. This can slow down a DTT, though.
If you figure something else out please post it here.....
cl