Home > database >  'BCP not internal or external command, nor can run the program
'BCP not internal or external command, nor can run the program

Time:11-22

Such as: EXEC master.. Arbitrary 'BCP MI_R1_SN. Dbo. Product_info out d:/Temp. XLS - c - q -s "XXX" -u "sa" -p "XXX"'
Tip: after execution 'BCP not internal or external command, nor can run the program or batch file
System environment variables with the C: \ Program Files \ Microsoft SQL Server (x86) \ 100 \ Tools \ Binn;
C: \ Program Files \ Microsoft SQL Server (x86) \ 80 \ Tools \ Binn
All was useless, for help!!!!!!
The use of SQL server2008 R2

CodePudding user response:

Save the path writing write wrong, change to d: \ Temp. XLS try

CodePudding user response:

reference 1st floor RINK_1 response:
save path of writing write wrong, try to d: \ Temp. XLS

Is written, so to find out why, inside environment variable path without BCP. Exe, direct wholesale search BCP. Exe, then put the path back to the system environment variable with respect to ok
  • Related