Re: Inserting 20 Million Rows to Oracle

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hello TM,

There are a few new Oracle related products coming online for SSIS. Maybe these will be quicker for you. I also believe the more recent versions of Oracle are able to see a Flat File as an external table so maybe this is an option for you as well.

http://www.persistentsys.com/products/ssisoracleconn/ssisoracleconn.htm


Regards

Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com

Day Two:

Talked with at least 5 different DBA types, and everyone is still
saying FTP and SQLLOAD. I hope this isn't the same in SSIS.



.