BCP- include field columns names

• GaffneyJ

  SSC Eights!

  Points: 856

  More actions

  September 22, 2017 at 8:30 am

  #328688

  Hello, 
  Just wondering If this is possible yet in SQL Server 2014? If not is there an easy way of doing this? I had a look around online but the threads were from a long time ago. Possibly this feature has already been added?

• Phil Parkin

  SSC Guru

  Points: 247125

  More actions

  September 22, 2017 at 10:36 am

  #1960555

  GaffneyJ - Friday, September 22, 2017 8:30 AM

  Hello, 
  Just wondering If this is possible yet in SQL Server 2014? If not is there an easy way of doing this? I had a look around online but the threads were from a long time ago. Possibly this feature has already been added?

  I don't think so. I wrote a CLR to get round this, not exactly 'simple', but now that it's written, it's effective.

  ---