Hi All,
Does anyone try to create a task in SSIS extract data from Oracle10g to SQL Server 2005
Regards,
Nicol
Connect Oracle10g from SSIS
Hot Topic
- How can I assign a value to a textbox programmatically in a report?
- SQK2K - Linked server security.
- SQL Mobile Installation Problem on Device
- T-SQL Select Statement executed inside the Visual Studio 2005 Environment returns -1 for the "True" Values of the bit fields
- Advenced select
- How to add reference in C# SQL Server Project (June CTP)
- A Problems after the install of the Hotfix
- Msg 6573 - method in assembly is not static - how do I make it static ?
- New Guy Question 2: SQL on-the-fly at package runtime?
- Starting to use SQL Server 200 Exp
SQL Server
- Derived Column return WRONG datatype.
- Sql server Express edition installation (OS Windows Home XP)
- Move stored procs from 2000 to 2005
- How to store a complex query result somewhere and refresh it hourly/daily/on demand?
- Schema changes no longer replicated to subscribers
- Advice on SQL Server 2005 vs. Express Edition w/ Advanced Services
- cannot open a jscript file
- connecting to sql server from mobile device
- Distinct Count in a new Measure Group
- Creating and Configuring Custom Conflict Resolver.
Connect Oracle10g from SSIS
Miyamoto M
I am going to implement data warehouse system using SQL Server 2005. I would like to have some proven document which shows that SSIS is certified to extract data from Oracle10g. Also would like to know the component required in the server (e.g., ODBC Driver, Oracle Client etc.).
Appreciate if someone can share with me.
ACS
CConchelos
HI Bogey,
I am still searching such information. Appreciate if you can share with me. Thanks.
Joe2005
Nicol,
The SSIS data-flow should be able to handle this without too much trouble. What problems are you having
-Jamie
bobbynad
Persistent Systems has a Bulk load connector for Oracle 10g (http://www.persistentsys.com/products/ssisoracleconn/ssisoracleconn.htm)
They are also planning a high perf Oracle source (its currently in alpha eval with a few customers). It can extract 1M rows (20 MB data) in ~15secs.
barbbayne
There's no certification as such but you'll have to trust me that it can be done. SSIS can work with data from any heterogenous source for which there is an OLE DB Provider - Oracle falls under this category.
You have a number of options:
On my current project we use Microsoft's OLE DB Provider for Oracle extensively and it works fine.
-Jamie