What size firewire cable do i need to upload footage from my sony ccd trv66 to my mac?

Probably four pin to six pin, although your your computer may not be 6 pin. That is something you should know and only you.