Stargate SG-1 S05 E03 Ascension

"Saving the world... one episode at a time"

An alien being is smitten with Carter and follows her back to Earth. It assumes a human form and pursues a relationship with her.