Stargate Atlantis S02 E04 Duet

"A new gate will open. A lost city will rise again."

A run-in with a Wraith Dart leaves the consciousness of a precocious Atlantis security officer trapped in Dr. McKay's mind.