L.B.
The trick to learning any new language is simply to have a place to practice it. Rosetta Stone is a good product and your child will pick up some vocabulary from it. That said, your child will likely not learn how to actually communicate in that language without ever practicing the language with people that speak it.
You haven't said how old your child is, but it's more critical that you find places for your child to use the new language (extra curricular programs, schooling in that language, friends that speak the language etc), unless you speak the language at home, in which case you can just simply start talking to your child in that language.
Good luck!