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
to.

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.

MBH

Sent via Deja.com http://www.deja.com/
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'

output                                                                            

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