If you look at the Eye-Fi Wi-Fi SD card, it will transfer to a folder, but requires their Eye-Fi Manager Software running. Once an image arrives in a folder, Aperture Hot Folder script will drop it into Aperture (either 1.5.6 or 2.0.1). So if the SD card works in your camera, you should be able to do it.
I would check how far you can be from the computer for the SD to work and how fast the images are transfered. Also I would want to know whether the images remain on the card just in case there are transmission problems.