Star Trek: Deep Space Nine (1993): Destiny

Stardate: 48543.2. Sisko faces a conflict between his Starfleet duties and his role as the Bajoran Emissary when an ancient Bajoran prophecy predicts that a joint Federation-Cardassian project will lead to the destruction of the wormhole.