Conclusion SQL Server 2008 and 2008 R2 (Enterprise editions) support bulk load of Oracle data using SSIS packages. For SQL Server 2005 and the non-Enterprise editions of SQL Server 2008 and 2008 R2, the following are alternatives for optimizing the loading of Oracle data. Script component bulk loads data to Oracle using the Oracle OLE DB provider from Oracle Third-party components that connect to Oracle, from CozyRoc, Persistent, and DataDirect For more information: ( ) ( ) (http://www.rafael-salas.com/2010/06/ssis-and-netezza-loading-data-using-ole.html) Did this paper help you? Please give us your feedback. Tell us on a scale of 1 (poor) to 5 (excellent), how would you rate this paper and why have you given it this rating? For example: Are you rating it high due to having good examples, excellent screen shots, clear writing, or another reason? Are you rating it low due to poor examples, fuzzy screen shots, or unclear writing? This feedback will help us improve the quality of white papers we release. .
Conclusion SQL Server 2008 and 2008 R2 (Enterprise editions) support bulk load of Oracle data using SSIS packages. For SQL Server 2005 and the non-Enterprise editions of SQL Server 2008 and 2008 R2, the following are alternatives for optimizing the loading of Oracle data. Script component bulk loads data to Oracle using the Oracle OLE DB provider from Oracle Third-party components that connect to Oracle, from CozyRoc, Persistent, and DataDirect For more information: ( ) ( ) (http://www.rafael-salas.com/2010/06/ssis-and-netezza-loading-data-using-ole.html) Did this paper help you? Please give us your feedback. Tell us on a scale of 1 (poor) to 5 (excellent), how would you rate this paper and why have you given it this rating? For example: Are you rating it high due to having good examples, excellent screen shots, clear writing, or another reason? Are you rating it low due to poor examples, fuzzy screen shots, or unclear writing? This feedback will help us improve the quality of white papers we release. .
Optimized_Bulk_Loading_of_Data_into_Oracle.docx