bcp error: Unable to open BCP host data-file

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server Express » bcp error: Unable to open BCP host data-file

bcp error: Unable to open BCP host data-file

Rate Topic

Display Mode

Topic Options

Author

Message

manas.panda

Posted Thursday, December 18, 2008 12:25 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, February 04, 2013 1:54 AM
Points: 180, Visits: 241

I get this error message:

SQLState = HY000, NativeError = 0
Error = [Microsoft][SQL Native Client]Unable to open BCP host data-file

if I try to run

EXEC master..xp_cmdshell
bcp "select top 100 * from test.dbo.Table_1" queryout "c:\data.txt" -c -Usa -Psa123 -SD-D-MIRS\SQLEXPRESS'

from Query Analyzer (or a store procedure).

If run the same command in cmd or run window (without EXEC and xp_cmdshell) I do not get any error and the content of the table is exported in the file I want...

If the exported file is on a local folder on the server everything is working fine even in Query Analyzer...

Thank
Manas

Post #621818

devendernaik

Posted Sunday, January 31, 2010 1:26 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, May 01, 2012 7:08 AM
Points: 1, Visits: 22

Make sure cmdshell is enabled.

The best way is to create a job and make sure the Job is running under the correct user which has the rights to read/write to the folder.

Post #856857

chenn

Posted Thursday, March 10, 2011 6:55 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, March 10, 2011 6:49 AM
Points: 1, Visits: 5

Hi,

I had the same scenario.

Check the sql server service, it should be running with permissions for the folder that you're extracting to.

I'm using SQL express 2008 R2 with a Local system account.
It didn't work, because it was configured to use a Network Service.

Best regards,
Chen

Post #1076209

Jason Gibson

Posted Tuesday, August 07, 2012 4:50 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 4:23 AM
Points: 15, Visits: 175

I received a similar error message when running a bcp command from SSMS, however it ran ok from a command prompt.

The SQL Service Account didn't have write permissions to the output file location!

Post #1341147

« Prev Topic | Next Topic »

Permissions