Post reply

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

  • 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...

  • 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.

  • 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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply