SQL Server Performance Forum – Threads Archive
error using bcp
Hiwhen 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
wt214
-U quantumuser -P g00fy
SQLState = S1000, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]Unable to open BCP host data-file
thankyou
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
***********************
http://weblogs.sqlteam.com/dinakar/
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
http://www.SQL-Server-Performance.Com
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.
]]>