Hi, folks :
I am now working on a project to use SSIS to integrate all other systems from different platforms into one. One of our system is in Oracle 9i. What is the best practice to ETL data from Oracle to Sql Server 2005 using SSIS. Do we create a package to do it Any book, manual, scripts I should read. pointers, hints are very much appreciated. Thanks again.
reading material to use SSIS accessing Oracle
Hot Topic
- An instance of the SQL Server Reconciler error object cannot be created
- Howto suppress FETCH output
- ODBC Destination in SSIS
- Bug? No WSDL information fo a WEBMETHOD that points to a table-value function
- Memory Error
- Custom component seems to un-register itself?
- Conditionally referring to fields
- Deployment Server Properties
- Connectioni leak with MDAC 2.82
- HELP: Failed to create the task. (Microsoft Visual Studio)
SQL Server
- Remote connection of SQL Express
- Need a help
- URL rending vs embedded reports
- Using Teradata .NET data provider as data source
- File growth problem in 2005
- Problem adding Annotations to KPIs
- 2 data sources
- Mapping of SQL Server data types to Integration Services Data Type
- Do you regularly reboot your server?
- Crosstab in SQL 2000./.net 2003
reading material to use SSIS accessing Oracle
dakhili
Whether your sourceing from Oracle or any other data source the fundamentals of SSIS are pretty similiar. The only gotcha's i've seen with oracle so far is its inability to always determine the proper code page, and the inability to use parameters with the native oracle ole db provider, two fairly simple problems to work around.
Check out project real for examples of an ETL solution. Also check out the SSIS samples with SQL2K5.
http://www.microsoft.com/sql/bi/ProjectREAL/default.mspx