<div>
because you want to move data from Oracle to SQL and not the other way round maybe you should post this on the Oracle <br />
channel.
</div>


because you want to move data from Oracle to SQL and not the other way round maybe you should post this on the Oracle
channel.

<div>
<div class="content wysiwyg-content">
I am wanting to dump some data from a Oracle DB into a SQL temp table to use in other MS SQL queries. Can this be done?
</div>
</div>


I am wanting to dump some data from a Oracle DB into a SQL temp table to use in other MS SQL queries. Can this be done?

Connecting to a Oracle DB using MS SQL Opendatasource

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.