Alternative for OCI(Oracle Call Interface) to bulk insert records

• pawan.mantha

  SSC Veteran

  Points: 274

  More actions

  March 13, 2019 at 8:08 am

  #382013

  Currently we have logic for Oracle using OCI for bulk insert records please any one let me how can we achieve in SQL server for the same.

• Mark Cowne

  One Orange Chip

  Points: 26952

  More actions

  March 13, 2019 at 8:18 am

  #2024327

  For .NET use SqlBulkCopy, for native e.g. C/C++ use BCP ODBC.

  ____________________________________________________

  Deja View - The strange feeling that somewhere, sometime you've optimised this query before

  How to get the best help on a forum

  http://www.sqlservercentral.com/articles/Best+Practices/61537