Grant Fritchey (8/4/2010)
Brandie mentioned SSIS, which is SQL Server Integration Services. It's the built-in SQL Server ETL (Extract/Transform/Load) tool. She was suggesting that if they could deal with day old data, to set up an SSIS job to move the data on a daily basis, probably during off-hours.
Exactly. Basically, SSIS could export the data in almost any format and then your Oracle people could create a job to load the data nightly into their database.
Though I haven't dealt with Oracle before, you might also be able to use SSIS to directly load Oracle using one of the available connection managers in SSIS. But that would require access to the Oracle DB.