Export to CSV using bulk copies data, can't write to local

• dejanbltamamovic

  Valued Member

  Points: 53

  More actions

  November 9, 2017 at 12:20 am

  #340436

  Table in my db should be exported to csv file via bcp query. I managed to export it on the Server side drive, and it is just fine, but I can't export to local machine.

  I shared drive, granted full control to everyone. When I remotely run the server I am not able to ping my machine as request always times out, on the other side, server is accessible from my machine.

  I tried to access shared folder on my colleagues computer. Now I can access his shared folder but the error I am receiving when trying to execute my procedure persisted and writing to server remains the only option.

  Here is what I've done...

  

  

• Wayne Sheldon

  SSC-Addicted

  Points: 460

  More actions

  November 9, 2017 at 2:08 am

  #1967315

  Can you try mapping the drive first - so its X:\OutputFiles.csv

  It could be down to the backslash being recognised as an escape character instead of a backslash.

• Thom A

  SSC Guru

  Points: 99143

  More actions

  November 9, 2017 at 2:54 am

  #1967322

  I imagine it's a permissions issue more than anything. I assume that you have configured a Service account on your SQL Server and that you have granted that Service Account access to that directory?

  Thom~

  Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
  Larnu.uk