I was anticipating hassles and anal probes at the airport, so I got there early... but I have to say, check-in went off without a hitch. I told the lady at the counter that I was traveling with a firearm, and she actually looked kinda surprised, like she had to think back to her training on what to do.
She asked me to unlock the case, I demonstrated that the weapon was indeed unloaded, and she stuck a red slip of paper in the case that said "Unloaded firearm"... she then told me to stand aside, my bag was handed off to a TSA official who took my bag to an X-ray machine. 2 minutes later, he gave me a thumbs up, and I was off to my gate.
On the return, the lady at the ticket counter again looked surprised, called over a supervisor, but we did the unloaded check and the red slip of paper, and this time, I did not have to wait for TSA... I proceeded directly to my gate.
So all in all, things went great... no hassles at the airport, I got my business concluded, got to see some old friends, and felt secure in the knowledge that I was armed in an unfamiliar, albeit probably very safe little town.
If your permit is valid in your destination state, don't be deterred from taking your weapon... from my experience, I think traveling with a dog or golf clubs would be a much bigger hassle...