Skip to main content
Database Administrators

Return to Answer

added 12 characters in body
Source Link
Marco
Marco
  • 3.7k
  • 5
  • 24
  • 31

Error = [Microsoft][ODBC Driver 11 for SQL Server]Unable to open BCP host data-file.

Error = [Microsoft][ODBC Driver 11 for SQL Server] Unable to open BCP host data-file.

  • related to this error, it because of the BCP cannot open the output directory. like: exec master..xp_cmdshell 'bcp "select * from [TestDB].[dbo].[tbl]" queryout "C:\Test"'exec master..xp_cmdshell 'bcp "select * from [TestDB].[dbo].[tbl]" queryout "C:\Test\"'
  • change the output directory from D:..\D:..\ to C:..C:..\, it will be okOK as iI used to meet this.

Error = [Microsoft][ODBC Driver 11 for SQL Server]Unable to open BCP host data-file.

  • related to this error, it because of the BCP cannot open the output directory. like: exec master..xp_cmdshell 'bcp "select * from [TestDB].[dbo].[tbl]" queryout "C:\Test"'
  • change the output directory from D:..\ to C:.., it will be ok as i used to meet this.

Error = [Microsoft][ODBC Driver 11 for SQL Server] Unable to open BCP host data-file.

  • related to this error, it because of the BCP cannot open the output directory. like: exec master..xp_cmdshell 'bcp "select * from [TestDB].[dbo].[tbl]" queryout "C:\Test\"'
  • change the output directory from D:..\ to C:..\, it will be OK as I used to meet this.
Source Link
Phearin Sok
Phearin Sok
  • 1

Error = [Microsoft][ODBC Driver 11 for SQL Server]Unable to open BCP host data-file.

  • related to this error, it because of the BCP cannot open the output directory. like: exec master..xp_cmdshell 'bcp "select * from [TestDB].[dbo].[tbl]" queryout "C:\Test"'
  • change the output directory from D:..\ to C:.., it will be ok as i used to meet this.