Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 HELP : Importing from SQLServer 2005 to Oracle 10G

Author  Topic 

fabioazul
Starting Member

1 Post

Posted - 2008-12-17 : 13:21:23
Hello,

I am trying to export data from a SqlServer 2005 to Oracle 10G using SSIS , but I have to use the fast load option to commit the transaction on every 10000 rows.

I've tried to use the "Oracle OLE Provider" and the "Microsoft OLE Provider for Oracle", but I could not access the fast load options to use this attribute... the option simply does not appear.

Someone could help me ?

Thanks !



FabioAzul
   

- Advertisement -