How to train a dog not to bark?

I have a weiner dog and whenever somone visits the house he goes insane!We tell him No,we put him in a different room,or we try to calm him down by petting him,but nothing works.At first he starts to bark at the person.He goes crazy!!!He’ll stop occasionally,but then start again.He gets upset if they don’t hold him somtimes.We don’t use a skwirt(or however you spell it)bottle because he likes it.Do you have any ideas because my sister is coming over to visit on Friday and she has a 4 month old baby.I don’t want him to scare her.