Does hysterosalpingogram (HSG) procedure hurt?

I am about to ask my doctor to do it, and would like to know if it hurts cause i have heard it is extremely painful. In any case I will do it if needed regardless how painful it is. So please share with your experience, and if any success stories?