Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Command line BCP return code?

Status
Not open for further replies.
philmck

philmck

Programmer
Feb 19, 2004
8
GB
I have inherited a batch script which runs a number of bcp commands. My problem is that it currently tries to use the DOS style errorlevel to check for errors:

bcp "DB..TABLE" in textfile.asc .......etc
if errorlevel 1 ...etc
bcp "DB..TABLE2" in textfile2.asc .......etc
if errorlevel 1 ...etc

It seems the errorlevel is not set when bcp fails. Wondering if there is a return code or some way of trapping the error when using command-line bcp ?

Any suggestions appreciated, thanks.
 
Status
Not open for further replies.

Similar threads

Brianfree
  • Locked
  • Question
return unique rows only
Replies
11
Views
654
Brianfree
Brianfree
TheBugSlayer
  • Locked
  • Question
How to make xp_cmdshell use SQL Server's bcp utility instead of Sysbase's 1
Replies
7
Views
1K
Nick_Evans1
Nick_Evans1
Cpreston
  • Locked
  • Question
Will not show row with Line Type 2 1
Replies
17
Views
887
Cpreston
Cpreston
briangriffin
  • Locked
  • Question
Function Returning Rowcounts
Replies
1
Views
333
briangriffin
briangriffin
G12Consult
  • Locked
  • Question
Help with some code
Replies
2
Views
287
SaltyTheFrog
SaltyTheFrog

Part and Inventory Search

Sponsor

Back
Top