Macro flash lighting questions

When trying to do (almost) macro shots with hand held off camera flash I am having a hell of a time finding a proper balance between the key light and the sun. Part of the problem is that I can't seem to hold the flash at a consistent distance from the object especially when I'm trying to track a bee that must have found a stash of meth somewhere. All of the flash brackets that I've seen hold the flash directly above the axis of the camera which I don't necessarily want.

The light is totally flat without the contrast that two lights would provide.
Thanks in advance!

The light is totally flat without the contrast that two lights would provide.
Thanks in advance!
0
Comments
http://www.kenrockwell.com/nikon/r1c1.htm
or something similar?
"Your decisions on whether to buy, when to buy and what to buy should depend on careful consideration of your needs primarily, with a little of your wants thrown in for enjoyment, After all photography is a hobby, even for pros."
~Herbert Keppler
I found this thread that might be interesting for you; there are others, also
www.ivarborst.nl & smugmug
I am not familiar with the off camera flash controls available in the Sony system. You can certainly trigger your flash in Manual if the Sony accepts a PC cord, but shooting moving insects in manual flash can be challenging.
Moderator of the Technique Forum and Finishing School on Dgrin
I think that I'll keep using manual for most stuff since I love the control that it gives me but for stuff that is chaotic and constantly changing and close-ups that I have no control over TTL kicks some serious ass. I haven't done anything postable yet, just some quick test pops since I've been really busy with my real job, but I wanted to thank you all, especially Pathfinder, for the help.
P.S. DG really needs a :dumbass smiley. That head scratching guy doesn't even begin to convey the depths of my stupidity on this one.
Now get out there and grab a few macros.
Moderator of the Technique Forum and Finishing School on Dgrin