I'm trying to use oracle as destination and i'm not getting fast load option. Im getting error when i use fast load

Expert

Hi,

Most probably the Oracle OLE DB driver you are trying to use doesn't support Fast Load option.

If you can use third-party solutions, check the commercial COZYROC Oracle Destination component. It is 10-30x faster compared to regular insert.

You can also use ADO.NET destination task with bulk upload option to do your task.

Hi Bhadri1991,

I agree with COZYROC that the root cause may be that the Oracle driver you used doesnt support Fast Load/Bulk Insert. For example, the Microsoft OLE DB Provider for Oracle doesnt support Fast Load. In your post, you said that it threw errors when you use the Fast Load option, it seems that you were using the SQL Server Native Client provider which provides Fast Load option but cannot be used to connect to an Oracle database.

Here, you can use the Oracle OLE DB Provider provided by Oracle which is tested to have a high performance loader although it doesnt supports Bulk Insert/ Fast Load either. If you use SSIS 2008 or higher and the SQL Server Edition is Enterprise, you can also use the Microsoft Connectors for Oracle which supports Bulk Insert.

Reference:
https://social.technet.microsoft.com/wiki/contents/articles/1957.ssis-with-oracle-connectors.aspx 

Regards,

If its 2008 or above you can use high speed attinuity connetor for oracle

http://technet.microsoft.com/en-us/library/ee470675(v=sql.100).aspx

http://www.microsoft.com/en-in/download/details.aspx?id=292