Hi iam getting the following error when iam using bcp
C:\>bcp scp2.dbo.Inventory_Target_Level out \\kzo-sqlclup1\adexa\quantum_inv_tgt_lvl.dat -f \\kzo-sqlclup1\adexa\quantum_inv_tgt_lvl.fmt -S kzo-sqlclup1wt214-U quantumuser -P g00fySQLState = S1000, NativeError = 0Error = [Microsoft][ODBC SQL Server Driver]Unable to open BCP host data-file
please help me to resolve this issue
Its really urgent
The link above will solve the issue. Try and let us know.
My kind advice. You have posted your query as such and it has your user name and password in it. See to that you dont reveal such inform to others than the concerned persons. It will surely harm the security of your system.