error using bcp | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

error using bcp

when iam using bcp iam getting the following error can any body tell me how to resolve this please its very urgent C:>bcp scp2.dbo.Inventory_Target_Level out \kzo-sqlclup1adexaquantum_inv_tgt
_lvl.dat -f \kzo-sqlclup1adexaquantum_inv_tgt_lvl.fmt -S kzo-sqlclup1
-U quantumuser -P g00fy
SQLState = S1000, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]Unable to open BCP host data-file
pavan posani
Looks like the server is not able to access the mentioned directory path. Do an xp_cmdshell ‘dir \..’ to see if ou can see the files in the directory. ***********************
Dinakar Nethi
SQL Server MVP
To addup Dinakar’s reply:
Ensure to check the path/filename is correct or not, referred file exist or not and ensre file is not open by some other app. Also ensure relevant account running this BCP has relevant access privileges on that share. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.