It's not painful at all. I do nuclear stress tests once per year which is much more involved and not even that is painful - so don't fret it.
They'll just work your heart while hooked up to an ekg machine. Over and done in a half hour usually.
http://www.americanheart.org/present...dentifier=4568