What is the difference bewteen Bulk Insert and Openrowset and BCP?

• Lakshman.Shiva

  SSC Veteran

  Points: 234

  More actions

  October 3, 2008 at 2:17 am

  #73051

  Hi Guys,

  I am looking for differences between Bulk Insert and Openrowset and BCP? and what the procs and cons of each one and which one will be faster and why?

  Thanks,

  Shiva

• steveb.

  SSC-Forever

  Points: 46733

  More actions

  October 3, 2008 at 4:03 am

  #880364

  There a few differences, but the main one is that Bulk Insert is a T-sql command, and BCP is a command line program

  Check BOL for the rest..