Brandie Tarvin (8/4/2010)
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.
You can go directly to Oracle from SSIS. There's even a third party destination available to make it really easy to do.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning