Thanks Michael, I think I'm going to follow your suggestion and add an
intermediate transformation, because in addition to the count there
are some other issues with the data in its current form that need to
be corrected prior to the db load. Again, thanks for all your help
(and this likely isn't the last you've heard from me).

Regards,

Adil