SQLState = S1000, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]Unable to open BCP host data-file
I am getitng the above error when i am executinf BCP. The file location is not on the local machine. it is a network drive. Please help !
Whenever I get this message, it's because of one of three things:
1) The path/filename is incorrect (check your typing / spelling)
2) The file does not exist. (make sure the file is where you expect it to be)
3) The file is already open by some other app. (close the other app to release the file)
For 1) and 2) - remember that paths are relative to where bcp is executing. Make sure that bcp.exe can access the file/path from it's context.
i got this error while running a bcp command from the xp_cmdshell
if i run the bcp separately on the dos prompt, it runs fine
Anyone knows the info to correct this problem? Thanks
I am getting the same problem in the following scenario
I have created one table "T1" using filegroup "A" contains only data file "A_1.ndf" with size 100M and disaled autogrowth. This file group size reaches 100M means its 100% full. Now I am trying to archive this "T1" table data using bcp command as follows:
bcp T1 out D:\Archive -S <Server_Name> -U <username> -P <pwd> -b 10000 -c -t |;
it throws the below error:
"SQLState = S1000, NativeError = 0Error = [Microsoft][ODBC SQL Server Driver]Unable to open BCP host data-file"
While executing bcp command, does it requires some space in filegroup "A"?
Can any body help how to resolve this?