I would just plug the camera in directly and not bother with an USB to CF or SD to CF adapter. I hate that the camera connection kit only cares about SD cards. Pro cameras aren't really using that format.
There's another thread going on compatible devices. The consensus seems to be that the CF reader needs to be powered, either on its own or with a powered hub, or you get an error message.
That's just what a few people have found. I've got a generic multi-format card reader (non-powered) that works fine plugged directly into the iPad.
I'd tell you the name/model, but I really don't know. It's just a cheap 'no name' reader.
cool...please keep me up to date...thanks