Link from SQL server to oracle

Hi
What is the best and most robust/recommended way to link SQL server 2000
to oracle 9i DB?
We are planning to send daily load across the link and do not want it
to fail.
Tks
MangeshI used linked servers for that. Worked very well.
HTH, Jens Suessmeyer.
"Mangesh Deshpande" <MangeshDeshpande@.discussions.microsoft.com> schrieb im
Newsbeitrag news:2C3C1647-C94B-4C4A-BC85-389058124638@.microsoft.com...
> Hi
> What is the best and most robust/recommended way to link SQL server 2000
> to oracle 9i DB?
> We are planning to send daily load across the link and do not want it
> to fail.
> Tks
> Mangesh