Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2012
    Posts
    2

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

    Hi,

    I need to be able to use BCP in SSMS to export to a text file.

    Exec master..xp_cmdshell 'bcp "select name from sysobjects" queryout "C:\Nonah_Share\out.txt" -c -T -S'

    is not working

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

    The folder is shared with everyone and I have full admin rights to my local machine although I do not have the server installed just SSMS
    I am running SSMS 2005

    Can someone please assist?

    Thank you

  2. #2
    Join Date
    Aug 2003
    Location
    West
    Posts
    101
    Maybe the service account for ssms does not have permission to folder?

  3. #3
    Join Date
    Jun 2012
    Posts
    2
    I got it... No it was I neeeded fully qualified \\myservername\Nona_Share\out.txt

    It works!

    Thanks for your help though

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •