Browse by Tags

Home ›

All Tags » Oracle » SSIS (RSS)

Re: Need to load a Sql Server temp table from a Oracle select results

May be you should use SQL Server Integration Services. Set up a data flow task, get data from Oracle and push it to a SQL Server table. You may not even need to write code, but there may be some data conversions needed which can also be configured in SSIS. If you are not proficient in the use of SSIS...

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by mysorian on 04-16-2009, 12:00 AM
Filed under: oracle, SQL Server 2008, DTS, ssis, SSIS 2005
Fastload Tables into Oracle 10 through SQL Server 2005 SSIS

Hi. I know there is no easy way to do fastload through SSIS to an Oracle destination, so I have rearchitected the feedback portion of my ETL (99.9% from Oracle to SQL Server 2005, just a little feeding back to Oracle to allow server side filtering) so that there is just one place where it happens and...

Posted to Oracle (Forum) by Charles Asbornsen on 10-30-2008, 12:00 AM
Filed under: Oracle, ETL, FastLoad, SSIS
Moving data via SSIS.

Hi, all. This is a basic SSIS question. IA co-worker of mine created several SSIS packages in Business Intelligence Development Studio. I have to use those packages to move data from an old database to a new one. (Creating new packages isn't an option.) My problem: A coworker created some SSIS packages...

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Frederick on 09-10-2009, 12:00 AM
Filed under: Asp.Net 2.0, Oracle, SSIS, SQL 2005 Server
SSIS, preserving foreign key constraints.

Hi, all. For the past few days, I've been trying to use SSIS to migrate data in tables from a SQL Server database to an Oracle database. I need to retain foreign key constraints while doing it. I'm not in a position to remove foreign key constraints, then add them back. The problem is that each...

Posted to Oracle (Forum) by Frederick on 09-24-2009, 12:00 AM
Filed under: Oracle, SSIS, foreign key