I'm pretty sure SQL Server 2005 onwards supports replication to Oracle, which is what you're trying to do.

It looks complicated but it's the 'out of the box' way to do it.

http://msdn.microsoft.com/en-us/library/ms151738(v=sql.90).aspx