BCP using UNC path

• erajendar

  SSC Eights!

  Points: 840

  More actions

  September 6, 2010 at 12:17 am

  #140408

  HI - We are using BCP utility to write the query to a text file. When we write to local file it is writing without any issues. However, issue is coming when we write the data to UNC path. Can some one tell me how to access the UNC path to write the data to text file using bcp utility.

  select * into ##menu_item_test from menu_item

  DECLARE @StmtVARCHAR(8000)

  SET @Stmt = N' BCP "select * from ##menu_item_test " QUERYOUT \\192.11.1.1\Drops -c -T'

  EXEC XP_CMDShell @Stmt

  I am getting the below error:

  SQLState = HY000, NativeError = 0

  Error = [Microsoft][SQL Native Client]Unable to open BCP host data-file

  NULL

  thanks

  
  erajendar

• Steve Jones - SSC Editor

  SSC Guru

  Points: 734449

  More actions

  September 17, 2010 at 8:29 am

  #1223046

  I believe when you run this that the SQL Server service account might need rights to the destination.