How effective is the Rosetta Stone software package at teaching a foreign language?

I have been toying with buying the full Spanish software package for professional reasons, but I want to hear some critiques first.

Anyone have any success?