Stargate Atlantis S04 E09 Miller's Crossing

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

Rodney McKay goes in search of his sister on Earth after she is kidnapped by the head of a powerful corporation.