Stargate Atlantis S04 E05 Travelers

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

Colonel Sheppard is captured by the inhabitants of a generational ship and their beautiful leader, who wish to use his ability to use Ancient technology for their own ends.