Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  BCP function problem

Author  Topic  mickp Starting Member 2 Posts Posted - 2001-01-03 : 13:35:02 Hi, I'm using the function bcp to transfer data from my table to a data file. When I use it at the dos command prompt, no problem everything works really well. But if I use query analyser I have an error: unable to open bcp host data-file. Here's the line: xp_cmdshell 'bcp table.owner.inventaire out c:\1\test.txt -Ssql -Usa -P' The problem is not with xp_cmdshell because I can call simpler executables in query analyser.