Hi,
why Table or View – fast load option in Data Access mode is not listed when we connect Oracle Database in the OLEDB Destination.
Thanks
Jegan
When you switch data sources using an OLE DB destination, you are most probably using a different kind and version of the OLE DB provider. I'm guessing that in your case, you are using Microsoft's Oracle OLE DB provider? that `-fast load` option is a feature of the underlying OLE DB Provider, which in your case, I'm guessing is Microsoft's OLE DB provider (SQL Native Client). And that is probably not a feature of the underlying OLE DB Provider for Oracle that you are using, and thus, do not show-up as an option.
|||Thanks Deniz.
No comments:
Post a Comment