I'd really like to create some sort of link from oracle to sql server, so changes in my oracle db could be triggered into sql server (roughly an "automatic data warehouse"). It's easy to link to oracle from sql server, but I'm baffled by the process (if even possible) going the other way. I'm using sql server 2000 and oracle 9i (I also have some ss version 7 and oracle 8 floating around my organization). Alternatively, I could use a little help calling a COM object to handle the task (vb6 code in a dll). Either way, I'm looking for real-time automation of this transfer.

Any help is greatly appreciated!