I came up with a new idea after a couple hours of searching google.

Visor>Fluid Examples>Blowing Surface Snow
now I just have to figure out how to edit this to look like sand. hopefully this will be easier than realflow.

edit: Wow, I'm having a real hard time getting a sand flow going the way I want. I don't know if I should be doing maya fluids, maya dynamics, realflow, or what... maybe I'll have to forget about the sand blowing idea, although I think it would look cool if I knew how to do it.