Star Trek: Deep Space Nine S03 E15 Destiny

"At the edge of the Final Frontier, the Universe's greatest mystery is about to unfold."

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.