Errors running bcp command

Errors running bcp command

Post by Michael Hopkin » Wed, 24 May 2000 04:00:00

Whilst trying to carry out a bcp from within SQL server 6.5 with the
following command line structure

EXEC master..xp_cmdShell "bcp database.dbo.table in 'filepath'
        /f'formatpath'  /e'errorpath' /Uusername /Ppassword /Sserver"

 I get the following error

Cannot find the function 'xp_cmdShell' in the library 'xpsql60.dll'.
Reason: '127(The specified procedure could not be found.)'

I have not been able to find out what this means but have not been able

I am using the account as a non sa and have permissions to execute
xp_cmdShell. Apparently the sa has run xp_cmdShell within the database
server and it works OK.

Any help would be appreciated.


Sent via
Before you buy.


1. bcp command runs but results do not show up in text file

This query runs but I don't find the files in F:\Backup

Here's the syntax and result set.  Thanks, Mr. K

USE Master
EXEC xp_cmdshell 'bcp  "select  * from pubs..authors" queryout
"F:\Backup\pubs.txt" -fF:\Backup\my.fmt -S. -T'


usage: bcp {dbtable | query} {in | out | queryout | format} datafile
  [-m maxerrors]            [-f formatfile]       [-e errfile]
  [-F firstrow]             [-L lastrow]          [-b batchsize]
  [-n native type]          [-c character type]   [-w wide character type]
  [-N keep non-text native] [-6 6x file format]   [-q quoted identifier]
  [-C code page specifier]  [-t field terminator] [-r row terminator]
  [-i inputfile]            [-o outfile]          [-a packetsize]
  [-S server name]          [-U username]         [-P password]
  [-T trusted connection]   [-v version]          [-R regional enable]
  [-k keep null values]     [-E keep identity values]
  [-h "load hints"]

(11 row(s) affected)

2. Where can I find the ODS ODBC Gateway driver odsgate.dll and odsgat32.dll ?

3. How to run bcp command from vbscript ?? - Newbie

4. dts, login fail when change dts package

5. run bcp in command promt and query analyzer **

6. Compact Progress

7. RUN/! command error in applications run on Windows95

8. A2K ADO SQL7 conflict

9. Install sheild express,run command/run command parameters?

10. BCP command line / error capturing / bulk insert bugs

11. BCP Command Line Help Needed (End of File Error)

12. BCP command line / error capturing / bulk insert bugs

13. Error running BCP