• It depends on the OLE DB provider I think.

    It's possible the Microsoft OLE DB provider for Oracle (which is deprecated if I remember correctly) has a fast load option, but the Oracle OLE DB provider doesn't.

    Yeah that's what I remembered . May be Yashuvp can check that .

    Here is the link ..

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

    --

    SQLBuddy