Extract data from table to a remote path using BCP

• J S Gurumoorthy

  SSC Veteran

  Points: 218

  More actions

  January 8, 2007 at 4:39 am

  #118497

  How to extract data from table to a remote(shared) path rather than to the database server path?

  I tried with the following command :

  bcp "select * from tblemp" queryout "\\server\folder\test.txt" -c -t , -S "DBserver -o "1.TXT" -U "Sa" -P "password"

  and get the error msg as

  bcp: Unable to open output file \\server\folder\test.txt: Permission denied.

   

  can anyone help me out on this?

• January 11, 2007 at 8:00 am

  This was removed by the editor as SPAM

• J S Gurumoorthy

  SSC Veteran

  Points: 218

  More actions

  January 17, 2007 at 9:16 pm

  #683891

  Hi,

   I got the solution for this problem. I changed the MSSQLSERVER and SQLAgent service account to my domain account and it works fine.